Use this tag for questions specific to the 2005 version of Microsoft's SQL Server.
I have a couple of properties in C# which are double and I want to store these in a table …
c# sql sql-server sql-server-2005 tsqlI have two columns: job_start job_end 2011-11-02 12:20:37.247 2011-11-02 13:35:14.613 How would it be possible using T-SQL to …
sql sql-server-2005 date datediffCan anyone tell me where is the mistake in the following query ALTER TABLE Countries ADD ( HasPhotoInReadyStorage bit, HasPhotoInWorkStorage bit, …
sql-server-2005I am trying to connect to a Microsoft SQL 2005 server which is not on port 1433. How do I indicate a …
sql-server sql-server-2005 ssmsI'm looking for a way to temporarily turn off all DB's constraints (eg table relationships). I need to copy (using …
sql sql-server sql-server-2005 constraints entity-relationshipI have a MS SQL 2005 database with a table Test with column ID. ID is an identity column. I have …
sql-server sql-server-2005 tsql identity sql-server-2005-expressHow can I convert a String to a Date in T-SQL? My test case is the string: '24.04.2012'
tsql sql-server-2005I'm trying to perform some offline maintenance (dev database restore from live backup) on my dev database, but the 'Take …
database sql-server-2005 performanceI want a query to insert records from one table to another table in a different database if the destination …
sql sql-server-2005 integration appendIs there any way in which I can clean a database in SQl Server 2005 by dropping all the tables and …
sql sql-server sql-server-2005 tsql