Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Drop all constraints in a database

    when you drop constraints in the database, you need to drop them in order, foreign key constraints first, then others. Here is the script, assumes tables are owned by [dbo]

    --...

  • RE: CharIndex function, a bug???

    The results I get in my SQL Server 2005 are as per Sushilas finding. But not in SQL Server 2000 (v8.00.194)

  • RE: Null comparison question

    Thanks Carl for the reply. But still does not work.

    Here is a my test in SQL Server 2000 Query Analyser

    -- Warning !!!, dropping a table

    Drop Table T1

    Create Table T1 (C1...

Viewing 3 posts - 1 through 3 (of 3 total)