Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
How can I select 12/20/2008 in where clause of sql? The server is SQL server 2005. select * from tblErrorLog where errorDate = '12/20/2008…
sql sql-server datetime sql-server-2005 filterI am using SQL Server 2005. I have a table with a text column and I have many rows in the …
sql-server sql-server-2005 sqldatatypes notnull emptydatatextI am trying to convert a date with individual parts such as 12, 1, 2007 into a datetime in SQL Server 2005. I have …
sql sql-server sql-server-2005 tsqlI created a table on development environment for testing purpose and there are few sp's which are refreing this table. …
sql tsql sql-server-2005I am looking for a good SQL Statement to select all rows from the previous day from one table. The …
sql sql-server sql-server-2005I am trying to insert all values of one table into another. But the insert statement accepts values, but i …
sql sql-server sql-server-2005What are the differences between the SET and SELECT statements when assigning variables in T-SQL?
sql sql-server sql-server-2005 tsql sql-server-2008My table looks something like this: group date cash checks 1 1/1/2013 0 0 2 1/1/2013 0 800 1 1/3/2013 0 700 3 1/1/2013 0 600 1 1/2/2013 0 400 3 1/5/2013 0 200 -- Do not need cash just demonstrating that table has …
sql sql-server-2005 greatest-n-per-groupHow can I in change the table name using a query statement? I used the following syntax but I couldn't …
sql sql-server sql-server-2005I'm building a query with a GROUP BY clause that needs the ability to count records based only on a …
sql sql-server-2005