Ever need to disable some foreign key during the load of new data in some tables? (Eq: for a snapshot).
The following just does that using a parameter (0 for disable and 1 for enable)
This function returns the SQL Build Number as an int. i.e. 7, 8, or 9. @@Version is great, but super long, and the formatting of the string has changed over the years. This helps me find out what version of SQL I'm working on in a quick and efficient manner. The script includes the drop […]