Viewing 4 posts - 2,641 through 2,645 (of 2,645 total)
Here's one with divide by zero error removed and indentation:
------------------------------------------------------------------------
-- Purpose: Identify queries that are running slower than normal,
-- when taking...
August 7, 2008 at 6:26 am
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...
February 27, 2008 at 8:13 am
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
...
January 25, 2008 at 5:16 am
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...
January 2, 2008 at 9:11 am
Viewing 4 posts - 2,641 through 2,645 (of 2,645 total)