Forum Replies Created

Viewing 4 posts - 2,641 through 2,645 (of 2,645 total)

  • RE: Identifying Queries Running Slower Than Normal

    Here's one with divide by zero error removed and indentation:

    ------------------------------------------------------------------------

    -- Purpose: Identify queries that are running slower than normal,

    -- when taking...

  • RE: Insert Update Stored Procedure for a table

    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...

  • RE: NULL Equals NULL?

    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

    ...

  • RE: Document Your Database

    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...

Viewing 4 posts - 2,641 through 2,645 (of 2,645 total)