sql-server-2005 Archives - Page 6 of 7

I have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way ...

I am trying to connect to a Microsoft SQL 2005 server which is not on port 1433. How do I indicate a different ...

While studying for the 70-433 exam I noticed you can create a covering index in one of the following two ways. CREATE INDEX ...

In SQL Server 2005 I have a table cm_production that lists all the code that’s been put into production. The table has a ...

Using MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the table with the ...

I know I’ve done this before years ago, but I can’t remember the syntax, and I can’t find it anywhere due to pulling ...

I have a table which I want to get the latest entry for each group. Here’s the table: DocumentStatusLogs Table |ID| DocumentID | ...

I am using the following code to check if the temporary table exists and drop the table if it exists before creating again. ...

I have to update a field with a value which is returned by a join of 3 tables. Example: select im.itemid ,im.sku as ...

I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL ...