Check your default constraints
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
2018-09-17
2,043 reads
Andy Robertson
When sp_HelpText is not so helpful!
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
1,991 reads
2017-05-09 (first published: 2017-05-03)
1,190 reads
Blogs
Welcome to 3Cloud …
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
Daily Coping 23 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Forums
How to encode the following dynamical SQL scripts
I use one table (call first table) field's value to update another another table...
SQL Server Phone Home
Comments posted to this topic are about the item SQL Server Phone Home
A Strange Comparison
Comments posted to this topic are about the item A Strange Comparison
Ask SSC