Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
How can I get the table creation date of a MS SQL table using a SQL query? I could not …
sql sql-server tsql sql-server-2005I'm working on a database for a small web app at my school using SQL Server 2005. I see a couple …
sql-server sql-server-2005 storage varchar nvarcharI created a database on my local machine and then did a backup called tables.bak of table DataLabTables. I …
sql-server sql-server-2005 backup restoreUsing SQL Server 2005 and Management Studio how do I insert a picture into an Image type column of a table? …
sql sql-server sql-server-2005 imageI want to insert text with single quote Eg john's to table in sql server 2005 database
sql sql-server-2005 quotes quotationsEvery SQL Server connection string I ever see looks something like this: Data Source=MyLocalSqlServerInstance;Initial Catalog=My Nifty Database; …
sql-server database sql-server-2005 connection-string database-connectionWhat are the key differences between Microsoft's SQL Server 2005 and SQL Server 2008? Are there any compelling reasons for upgrading (any …
sql-server-2005 sql-server-2008 comparisonI have a project in SSIS and I've added an Execute SQL Task which sends its result out to a …
sql sql-server-2005 debugging ssis watchIs it necessary to use # before creating a temporary table in SQL server? Example: SELECT column1, column2, someInt, someVarChar INTO …
sql sql-server sql-server-2008 sql-server-2005How can I rollback an UPDATE query in SQL server 2005? I need to do this in SQL, not through code.
sql sql-server-2005 sql-update rollback