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:
-
Open On Screen Keyboard (OSK)
In order for this to work you need to follow these steps Go to “Project”, Select “ Properties…” Click on “Compile”, At the bottom of the screen click on “Advanced Compile Options…” Change “Target CPU:” to “AnyCPU” and click “OK”
-
-
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