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:
-
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”
-