Code | Ektron | MSSQL | MSSQL - Ektron 8.7 | SQL
-
-
SQLite – Auto-Increment / Auto Generate GUID
Recently was asked if it’s possible to create an auto-incrementing GUID in SQLite. Here is one approach: In Firefox there is an add-on called SQLite Manager (also available at https://code.google.com/p/sqlite-manager/) Open Firefox, in the “Tools” menu select “SQLite Manager” With SQLite Manager open click on the “Database” menu and select “New Database” Type in the…
-
MSSQL – Remove Line Breaks
Sometimes you need to remove line breaks or carriage returns, the code below should help. The above script will not work if the column type is TEXT so you must convert it first.
-
Product Key
This function can be used for various tasks but I happen to use it to make product keys cleaner or easier to read. Before: ABCDEFGHIJKLMNOPQRSTUVWXY After: ABCDE-FGHIJ-KLMNO-PQRST-UVWXY
-
-
-
MySQL to MSSQL Data Conversion
Ever have to take a MySQL database and put it in Microsoft SQL? This is a MySQL dump script that will assist you in this conversion. Only problem that I’ve had with it is that you need to review the exported SQL and make sure your version of Microsoft SQL will accept it.
-
Code | MySQL | WordPress | WordPress SQL
WordPress Change URL – MySQL – Update String Within Column
Recently I changed a domain alias for a WordPress site and needed to change the domain in all the pages/posts and this little script came in handy. Typical disclaimer stands, do a full backup before running this and verify you have everything setup correctly. If you have a network site first update your wp-config.php Secondly…
-
MSSQL Format U.S. Phone Number
If you have to sanitize your field first it gets ugly but is still possible Reference: http://www.sqlservercurry.com/2010/11/format-phone-numbers-in-sql-server.html
-