Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
While studying for the 70-433 exam I noticed you can create a covering index in one of the following two …
sql-server sql-server-2008 sql-server-2005 indexingMy questions is how to increment a column's value by 1. For example, suppose a column ID has values 1,2,3,4, .. Now when …
sql-server-2005I have a very basic LEFT OUTER JOIN to return all results from the left table and some additional information …
sql sql-server sql-server-2005 tsqlI've got data in SQL Server 2005 that contains HTML tags and I'd like to strip all that out, leaving just …
html sql sql-server string sql-server-2005I need a SQL query which add a new column after an existing column, so the column will be added …
sql sql-server sql-server-2005I want to connect from home using SQL Server 2005 to another PC. I had a look on the msd...but …
sql sql-server-2005 sql-server-2008 sql-server-ceWe have client app that is running some SQL on a SQL Server 2005 such as the following: BEGIN TRAN; INSERT …
sql sql-server sql-server-2005 transactionsI have a table like this: rowInt Value 2 23 3 45 17 10 9 0 .... The column rowInt values are integer but not in a sequence with …
sql sql-server tsql sql-server-2005SELECT logcount, logUserID, maxlogtm , DATEDIFF(day, maxlogtm, GETDATE()) AS daysdiff FROM statslogsummary WHERE daysdiff > 120 I get "invalid column name …
sql sql-server tsql sql-server-2005In SQL, I have col1 and col2. Both are integers. I want to do like: select col1/col2 from tbl1 …
sql-server sql-server-2005