I realy like this stored procedure. I have a system that uses UPSERTs where first you try to update a row using the primary key and if it the...

Whenever you compare NULL you should always use 'IS NULL' rather than '= NULL'

e.g.

[font="Courier New"]SET ANSI_NULLS ON

DECLARE @val CHAR(4)

SET @val = NULL

SET ANSI_NULLS ON

If @val = NULL

...

I agree, I've gone to the effort of writing a Word macro template to document SQL-Server databases. You just select an ODBC data-source for a SQL server database and it...