Use this tag for questions specific to the 2005 version of Microsoft's 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-2000How 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-proceduresI 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-2005I 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-updateI 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-tableI 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-2000I 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-2005In 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 tsqlI 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-datetimeI 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