T-SQL (Transact Structured Query Language) is the extension of SQL functionality supported by Sybase ASE and Microsoft SQL Server.
I have a table and one of the columns is "Date" of type datetime. We decided to add a default …
sql-server sql-server-2008 tsql alter-table alter-columnI have an existing table that I am about to blow away because I did not create it with the …
sql sql-server tsqlI'm trying to update the length of a varchar column from 255 characters to 500 without losing the contents. I've dropped and …
sql sql-server sql-server-2008 tsql varcharIf I issue SELECT username FROM Users I get this result: username -------- Paul John Mary but what I really …
tsql rows csvI have the following two tables: Table1 ---------- ID Name 1 A 2 B 3 C Table2 ---------- ID Name 1 Z I need …
sql sql-server tsql sql-insertI have MS SQL 2008 R2, 500 databases. What is the most efficient, easiest and 'modern' way to query all databases sizes. …
sql sql-server tsql sql-server-2008-r2I am creating a stored procedure to do a search through a table. I have many different search fields, all …
tsql optional-parametersCan you create an index on a table variable in SQL Server 2000? i.e. DECLARE @TEMPTABLE TABLE ( [ID] [int] NOT …
sql sql-server tsql indexing table-variableI'm an ASP.NET developer who has used Microsoft SQL Server for all my database needs (both at work and …
mysql sql-server tsqlI have created a foreign key (in SQL Server) by: alter table company add CountryID varchar(3); alter table company add …
sql-server tsql