Microsoft SQL Server is a relational database management system (RDBMS).
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-whenHow can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?
sql sql-server sql-server-2005 sql-server-2000SELECT 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 insertConsider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this …
sql sql-server csv string-concatenation group-concatIs 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 database with account numbers and card numbers. I match these to a file to update any card …
sql sql-server select join sql-update