Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
I have to update a field with a value which is returned by a join of 3 tables. Example: select im.…
sql sql-server tsql sql-server-2005 sql-updateI have this error message: Msg 8134, Level 16, State 1, Line 1 Divide by zero error encountered. What is the best way to …
sql sql-server sql-server-2005 sql-server-2008I want to get only Time from DateTime column using SQL query using SQL Server 2005 and 2008 Default output: AttDate == 2011-02…
sql-server tsql sql-server-2005 datetimeI've seen similar errors on SO, but I don't find a solution for my problem. I have a SQL query …
sql sql-server sql-server-2005How to convert a string to integer using SQL query on SQL Server 2005?
sql sql-server-2005I know I've done this before years ago, but I can't remember the syntax, and I can't find it anywhere …
sql-server tsql sql-server-2005 insertI would like to write a query on a sql 2008 that will report all the users that have access to …
sql-server sql-server-2005 sql-server-2008I'm writing an SQL Query, where a few of the columns returned need to be calculated depending on quite a …
sql sql-server sql-server-2005 select nestedUsing MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the …
sql-server sql-server-2005 tsql truncate foreign-keysHow can we check which database locks are applied on which rows against a query batch? Any tool that highlights …
sql sql-server database performance sql-server-2005