T-SQL (Transact Structured Query Language) is the extension of SQL functionality supported by Sybase ASE and Microsoft SQL Server.
In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (…
sql sql-server tsql selectHow do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = …
sql sql-server tsql if-statement caseThe OR operator in the WHEN clause of a CASE statement is not supported. How can I do this? CASE …
sql sql-server tsql case case-whenSELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part without the time part: 2008-09-22 00:00:00.000 How can I get …
sql sql-server tsql date datetimeI have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and …
sql sql-server tsql insertIs it possible to query for table names which contain columns being LIKE '%myName%' ?
sql sql-server tsql system-tablesHow do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? …
sql sql-server sql-server-2005 tsql stored-proceduresI have a start_date and end_date. I want to get the list of dates in between these two …
sql sql-server tsql datetime sql-server-2005I want to query the name of all columns of a table. I found how to do this in: Oracle …
sql sql-server sql-server-2008 tsqlWhat is the best way to get the names of all of the tables in a specific database on SQL …
sql-server tsql database-table