Inspired by a post here at SQLServerCentral, I wrote this function to calculate the number of days between two dates that are weekdays. In order to achieve this I used a common SQL table that contains a sequence of number for 1 to X. This was used as an input to the datediff function, and […]
2004-12-24 (first published: 2004-12-07)
313 reads
Found a version of this on the net. removed the loop and if/thens and made it a case statement 2004-03-11: Changed '@%@' to '%@%@%'
2004-03-08
425 reads
This function returns the difference between dates in the H:MM:SS format.
2004-03-05
267 reads
This is a bummed version of many of the "csv creating" scripts I've seen. No need to use a temp table or loop; the string can be built with one select statement (Select @String = isnull(@String + ',','') + Column From Table)
2003-11-10
375 reads
This script will record all the rows in all tables of the database it's run on. Then, at each execution, it will compare the rows to what they originally were and display those that are different (inserts or deletes):
2003-08-20
302 reads
This script will find all foreign key contraints in the database it is run on. Includes.Name of Foreign KeyName of table FK is onName of column FK is onName of table FK referencesName of column FK references
2003-08-01
143 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Max PK Length
Comments posted to this topic are about the item My experience using the GitHub...
Comments posted to this topic are about the item The Microsoft SQL Year in...
If I create a multiple column Primary Key constraint, what is the most number of bytes I can include in the constraint?
See possible answers