Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
I was wondering if there was a way to do this in MS SQL Server 2005: DECLARE @theDate varchar(60) SET @theDate = …
sql sql-server sql-server-2005 tsql dynamic-sqlHow can I insert datetime into the SQL Database table ? Is there a way to insert this query through the …
.net sql sql-server sql-server-2005 c#-3.0I can extract the month and day by using Day(Date()), Month(Date()). I can't extract hours, with HOUR(Date()). …
sql tsql datetime sql-server-2005 hourI want to update two tables in one go. How do I do that in SQL Server 2005? UPDATE Table1, Table2 …
sql sql-server sql-server-2005 tsqlI am involved in a data migration project. I am getting the following error when I try to insert data …
sql-server tsql sql-server-2005 migration data-migrationHow do I query DateTime database field within a certain range? I am using SQL SERVER 2005 Error code below SELECT * …
sql sql-server sql-server-2005 tsql sql-server-2008I want to return top 10 records from each section in one query. Can anyone help with how to do it? …
sql sql-server sql-server-2005 greatest-n-per-groupThe last few days we see this error message in our website too much: "Timeout expired. The timeout period elapsed …
.net asp.net sql-server sql-server-2005I have a table Emp which has these rows: Emp_cd | Val1 | Val2 | Val3 | Total -------+-------+-------+-------+------- 1 | 1.23 | 2.23 | 3.43 | 2 | 23.03 | 12.23 | 2.92 | 3 | 7.23 | 9.05 | 13.43 | 4 | 03.21 | 78.23 | 9.43 | …
sql sql-server sql-server-2005I want to rename a database, but keep getting the error that 'couldn't get exclusive lock' on the database, which …
sql-server sql-server-2005