T-SQL (Transact Structured Query Language) is the extension of SQL functionality supported by Sybase ASE and Microsoft SQL Server.
I am trying to select some fields from one table and insert them into an existing table from a stored …
sql sql-server tsql stored-proceduresI am involved in a data migration project. I am getting the following error when I try to insert data …
sql-server tsql sql-server-2005 migration data-migrationHow do I query DateTime database field within a certain range? I am using SQL SERVER 2005 Error code below SELECT * …
sql sql-server sql-server-2005 tsql sql-server-2008I need to write an Insert, Update Trigger on table A which will delete all rows from table B whose …
sql-server tsql triggersI have a SQL Table like this: | SomeID | OtherID | Data +----------------+-------------+------------------- | abcdef-..... | cdef123-... | 18,20,22 | abcdef-..... | 4554a24-... | 17,19 | 987654-..... | 12324…
sql-server tsql split commaIn SQL, how can I remove the first 4 characters of values of a specific column in a table? Column name …
sql sql-server string tsqlMy query is as follows, and contains a subquery within it: select count(distinct dNum) from myDB.dbo.AQ where …
sql sql-server tsql existsI wrote a T-SQL Statement similar like this (the original one looks different but I want to give an easy …
tsqlIs there a better way of doing a query like this: SELECT COUNT(*) FROM (SELECT DISTINCT DocumentId, DocumentSessionId FROM DocumentOutputItems) …
sql sql-server performance tsql query-optimizationAccording to MSDN, Median is not available as an aggregate function in Transact-SQL. However, I would like to find out …
sql-server tsql aggregate-functions median