T-SQL (Transact Structured Query Language) is the extension of SQL functionality supported by Sybase ASE and Microsoft SQL Server.
I have seen SQL that uses both != and <> for not equal. What is the preferred syntax and why? …
sql sql-server tsqlI need to access only Month.Year from Date field in SQL Server.
sql sql-server tsqlI have months stored in SQL Server as 1,2,3,4,...12. I would like to display them as January,February etc. Is there …
sql sql-server tsql sql-server-2005In SQL Server 2005 I have a table cm_production that lists all the code that's been put into production. The …
sql sql-server sql-server-2005 tsqlI want to convert a string like this: '10/15/2008 10:06:32 PM' into the equivalent DATETIME value in Sql Server. In Oracle, …
sql-server tsql datetime sql-server-2005 string-to-datetimeI want to update a column in a table making a join on other table e.g.: UPDATE table1 a …
sql-server tsql join sql-updateI have a SQL Server table that contains users & their grades. For simplicity's sake, lets just say there are 2 …
sql sql-server tsqlI have to update a field with a value which is returned by a join of 3 tables. Example: select im.…
sql sql-server tsql sql-server-2005 sql-updateWhat is the best way to get IDENTITY of inserted row? I know about @@IDENTITY and IDENT_CURRENT and SCOPE_…
sql sql-server tsqltable1 (id, name) table2 (id, name) Query: SELECT name FROM table2 -- that are not in table1 already
sql sql-server tsql