T-SQL (Transact Structured Query Language) is the extension of SQL functionality supported by Sybase ASE and Microsoft SQL Server.
I need a different random number for each row in my table. The following seemingly obvious code uses the same …
sql-server tsql sql-server-2000Could someone please explain the following behavior in SQL? SELECT * FROM MyTable WHERE MyColumn != NULL (0 Results) SELECT * FROM MyTable WHERE …
sql sql-server tsql nullI am trying to convert a date with individual parts such as 12, 1, 2007 into a datetime in SQL Server 2005. I have …
sql sql-server sql-server-2005 tsqlI would like to write a single SQL command to drop multiple columns from a single table in one ALTER …
sql sql-server tsql alterI created a table on development environment for testing purpose and there are few sp's which are refreing this table. …
sql tsql sql-server-2005Scenario: Let's say I have two tables, TableA and TableB. TableB's primary key is a single column (BId), and is …
tsql joinHow to pass an array into a SQL Server stored procedure? For example, I have a list of employees. I …
c# sql-server tsql stored-proceduresI have a deleted file archive database that stores the ID of the file that was deleted, I want the …
sql sql-server tsqlI have a procedure in SQL that I am trying to turn into Linq: SELECT O.Id, O.Name as …
.net linq tsql linq-to-entities sql-likeI am writing a Stored procedure in SQL Server 2008. I need to check if a table exists in the database. …
sql sql-server tsql sql-server-2008-r2