Category: MSSQL

File Extension

Posted on October 17, 2013October 26, 2015 By David Kittell

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.

Posted on October 15, 2013October 26, 2015 By David Kittell

Reference: http://msdn.microsoft.com/en-us/library/ms170572.aspx

Posted on October 14, 2013October 26, 2015 By David Kittell

Posted on October 10, 2013October 26, 2015 By David Kittell

Show first reference of ram Show last reference of ram

Posted on October 10, 2013October 26, 2015 By David Kittell

See Page View Details and Get City/State/Country From IP

Posted on October 10, 2013October 26, 2015 By David Kittell

Example:

Posted on September 30, 2013October 26, 2015 By David Kittell

Source: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/4126a010-6885-4eb0-b79c-c798c90edb85/how-to-split-comma-delimited-string

Posted on September 24, 2013October 26, 2015 By David Kittell

Posted on September 18, 2013October 26, 2015 By David Kittell

Posted on September 10, 2013October 26, 2015 By David Kittell

This is a compilation of some of the scripts on this site to get numbers to report to management