This area of the site is dedicated to code snippets for quick and easy reference
Sometimes you’re asked where a DMS file exists on the server and have to track it down, this query should help. Caveat: It helps to know where your root/main asset directory is on your server.
WARNING: Backup the computer you try these scripts on before you run these. These scripts will enable/disable the ability to save anything to the desktop.
WARNING: Backup the computer you try these scripts on before you run these.
With this example I only want an IP address so it’s rather clean and easy but you can essentially put any public webpage in place of “http://kittell.net/onlyip.php”
[raw] Click the button to get your coordinates: Try It [/raw] Source: http://www.w3schools.com/html/html5_geolocation.asp
Get Max Length Of Column
This script will remove all HTML tags from a given column in a table, useful if you need to simply have the text. Source: http://blog.sqlauthority.com/2007/06/16/sql-server-udf-user-defined-function-to-strip-html-parse-html-no-regular-expression/
When integrating various systems you sometimes need to convert DateTime values to an Integer, the code samples below will be helpful