Top "Sql-server-2005" questions

Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.

Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

sql sql-server sql-server-2005 sql-server-2000
Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? …

sql sql-server sql-server-2005 tsql stored-procedures
SQL query to select dates between two dates

I have a start_date and end_date. I want to get the list of dates in between these two …

sql sql-server tsql datetime sql-server-2005
How can I do an UPDATE statement with JOIN in SQL Server?

I need to update this table in SQL Server with data from its 'parent' table, see below: Table: sale id (…

sql sql-server tsql sql-server-2005 sql-update
Check if a temporary table exists and delete if it exists before creating a temporary table

I am using the following code to check if the temporary table exists and drop the table if it exists …

sql-server sql-server-2005 temp-tables alter-table
Check if table exists in SQL Server

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

sql-server tsql sql-server-2005 sql-server-2000
Convert Month Number to Month Name Function in SQL

I have months stored in SQL Server as 1,2,3,4,...12. I would like to display them as January,February etc. Is there …

sql sql-server tsql sql-server-2005
SQL Server query - Selecting COUNT(*) with DISTINCT

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

sql sql-server sql-server-2005 tsql
Sql Server string to date conversion

I want to convert a string like this: '10/15/2008 10:06:32 PM' into the equivalent DATETIME value in Sql Server. In Oracle, …

sql-server tsql datetime sql-server-2005 string-to-datetime
SQL Server - SELECT FROM stored procedure

I have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure …

sql sql-server sql-server-2005 stored-procedures