SQL RANK()
The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.
SQL Server ROW_NUMBER()
SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.
SQL SERVER EXCEPT
The SQL EXCEPT clause is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement.
SQL SERVER INTERSECT
The SQL INTERSECT clause is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.
Get the definitions of Stored procedures, User Defined functions and Triggers in SQL
How to get the full text descriptions / definitions of any stored procedures , UDF or triggers in SQL ? There are many ways to… Read More »Get the definitions of Stored procedures, User Defined functions and Triggers in SQL
SQL ERROR HANDLING WITH TRY..CATCH
The TRY CATCH block is used to handle exceptions in Transact-SQL code .
- « Previous
- 1
- 2
- 3
- 4