Reference: http://stackoverflow.com/questions/3276035/code-to-validate-sql-scripts
Category: Code
This area of the site is dedicated to code snippets for quick and easy reference
Page URL With Changing Variables
Often I’ve had to build a page that didn’t allow the datagrid or listview built in sort options so I came up with this function so that you can keep filters and change the sorting and direction of the page.
Alter Table
With this statement you would need to make sure that the column you wish to change does not currently have NULL values before running it otherwise you will likely have errors. With this statement you need to make sure that the column you wish to change only has unique values
Network Connection Configurations
If you are on Windows Vista/7/8 you will need to create the batch file and then run it as administrator. In the examples below you will need to first know what the connection name is for your network connection(s) When you click on the start menu or Windows key on…
Open/Close Elements
Sometimes you need to be able to hide elements on a page, the following functions will help with the task of hiding/showing those elements.
CopyText Via ID
This function is to copy text or other HTML elements from one ID to another ID
Hide/Unhide Element Via ID
In this code it is important to have visibility = ‘hidden’ and display = ‘none’ to hide without leaving white space In this code it is important to have visibility = ” and display = ” to show