Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
I want to list all sales, and group the sum by day. Sales (saleID INT, amount INT, created DATETIME) NOTE: …
sql sql-server sql-server-2005 group-byHow to delete all rows from all tables in a SQL Server database?
sql-server-2005I want to export some SQL Server 2005 data to CSV format (comma-separated with quotes). I can think of a lot …
sql-server sql-server-2005 bcp sqlcmdI am confused about a few points: What is the difference between a stored procedure and a view? When should …
sql sql-server-2005 stored-procedures viewsIn SQL Server 2005, I'm trying to figure out why I'm not able to insert multiple fields into a table. The …
sql sql-server sql-server-2005 tsqlI have been looking at CROSS / OUTER APPLY with a colleague and we're struggling to find real life examples of …
sql sql-server sql-server-2008 sql-server-2005I'm using a Microsoft SQL Server 2005 database with isolation level READ_COMMITTED and READ_COMMITTED_SNAPSHOT=ON. Now I want …
sql sql-server sql-server-2005 tsql read-committed-snapshotIs there any way I can find in SQL Server Management Studio stored procedure by name or by part of …
sql database sql-server-2005 ssmsPreamble I was modifying a column in SQL Server 2008 today, changing the datatype from something like currency(18,0) to (19,2). I got …
sql-server sql-server-2008 database-design sql-server-2005I know this is almost a duplicate of : The error "Login failed for user 'NT AUTHORITY\IUSR'" in ASP.NET …
.net sql-server sql-server-2005 web-applications iis-6