|
||||||
|
I had to create a script for dropping constraints on a table – no problem if the constaint is a named default, but if the default has a system generated name, it gets a bit hairy. Here’s an example of how the defaults get created: Create table TestTable1 I googled this and found Pinal Dave had [...] Here’s a simple script that I use often – a quick hitter to find table row counts, that doesn’t use the Select Count(*). It uses the sysindexes table thus the reason it’s called “fairly accurate”. SELECT Here’s a script I created to determine when I was going to be at specific miles for a marathon. It’ll give you your miles per hour and your minutes per mile. Then it’ll calculate at what time you will be at different mile marks. Set nocount on ———————————– /* |
||||||
|
Copyright © 2012 Lohn Solutions - All Rights Reserved |
||||||
