T-SQL (Transact Structured Query Language) is the extension of SQL functionality supported by Sybase ASE and Microsoft SQL Server.
What are the differences between the SET and SELECT statements when assigning variables in T-SQL?
sql sql-server sql-server-2005 tsql sql-server-2008Is there a straightforward way of finding the index of the last occurrence of a string using SQL? I am …
sql-server string tsql search sql-server-2000What is the difference between CROSS JOIN and INNER JOIN? CROSS JOIN: SELECT Movies.CustomerID, Movies.Movie, Customers.Age, Customers.…
sql sql-server sql-server-2008 tsql cross-joinUsing a Microsoft version of SQL, here's my simple query. If I query a record that doesn't exist then I …
tsqlI have a couple of properties in C# which are double and I want to store these in a table …
c# sql sql-server sql-server-2005 tsqlI have begun reading about Common Table Expression and cannot think of a use case where I would need to …
sql sql-server tsql common-table-expressionHow can I calculate the number of work days between two dates in SQL Server? Monday to Friday and it …
sql tsql dateI'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of …
sql-server list tsql variables reporting-servicesI have an SQL query to create the database in SQLServer as given below: create database yourdb on ( name = 'yourdb_…
sql-server database tsql collationWe have an old SQL table that was used by SQL Server 2000 for close to 10 years. In it, our employee …
sql sql-server tsql string-formatting