We can use try-catch blocks in TSQL since SQL Server 2005. In the try block; We write the TSQL code that we want to catch …

The PIVOT , which is indispensable for Excel users, can be implemented with SQL Server 2005 via T-SQL. But I can’t say it’s as talented …

  OUTPUT Clause transfers the records affected by the currently executed INSERT, UPDATE, or DELETE operations to the specified table. So we can easily capture …

  These are the special sorting functions that we can use to sort the data that we select from the tables at run time. ROW_NUMBER …

SQL Server supports grouping of data with GROUP BY since older versions, and also offers WITH ROLLUP and WITH CUBE operators for grand-total and sub-totals. …