Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
What's the difference between a Database and a Schema in SQL Server? Both are the containers of tables and data. …
sql-server database sql-server-2005 database-schemaWhere [CastleType] is set as data type "text" in SQL Server and the query is: SELECT * FROM [Village] WHERE [CastleType] = …
sql-server sql-server-2005 tsqlI have two t-sql queries using SqlServer 2005. How can I measure how long it takes for each one to run? …
performance sql-server-2005I am trying to read in a text file from an SQL query (SQL Server 2005) but am not having any …
sql-server sql-server-2005 xp-cmdshellI have installed Microsoft SQL Server 2005. This consists of the configuration tools (SQL server configuration manager, SQL Error and usage …
sql-server sql-server-2005 business-intelligence bidsI have to write a deployment script which will work if a stored procedure exists or does not exist. i.…
sql sql-server-2005 stored-proceduresI wonder how can i read a xml data and transform it to a table in TSQL? For example: <…
sql xml sql-server-2008 tsql sql-server-2005I want get the maximum value for this record. Please help me: SELECT rest.field1 FROM mastertable AS m INNER …
sql sql-server sql-server-2005 tsql aggregateConsider this trigger: ALTER TRIGGER myTrigger ON someTable AFTER INSERT AS BEGIN DELETE FROM someTable WHERE ISNUMERIC(someField) = 1 END I've …
sql-server sql-server-2005 triggersWhen I try to run the following SQL snippet inside a cursor loop, set @cmd = N'exec sp_rename ' + @test + …
tsql sql-server-2005