File Extension
If you are working in a database that has asset/file storage and need to get just the extension of the column this query will help save time.
-
-
Code | MSSQL | Windows Batch
MS SQL Import Txt File
Reference: http://msdn.microsoft.com/en-us/library/ms170572.aspx
-
-
Distinct For Only One Column
Show first reference of ram Show last reference of ram
-
Update IP Location Column
See Page View Details and Get City/State/Country From IP
-
Alter Table Column Data Type
Example:
-
Code | MSSQL | MSSQL - Functions | SQL
Delimiter Split
Source: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4126a010-6885-4eb0-b79c-c798c90edb85/how-to-split-comma-delimited-string
-
-
-
Code | Ektron | MSSQL | MSSQL - Ektron | MSSQL - Ektron 8.0.2 | SQL
Ektron Metrics Script
This is a compilation of some of the scripts on this site to get numbers to report to management