SQL WAITFOR
SQL WAITFOR statement is used to blocks the execution of a batch statement, transnational statement or any stored procedure until a specified time or any time interval is reached, or a specified statement modifies or returns at least one row.
SQL ERROR HANDLING WITH TRY..CATCH
The TRY CATCH block is used to handle exceptions in Transact-SQL code .
SQL Server PIVOT
SQL PIVOT allow us to aggregate the results and rotate rows into columns so in sort, we can say using PIVOT
SQL MERGE
SQL MERGE statement is used to modify data in a target table based on data in a source table.
SQL HAVING CLAUSE
SQL HAVING clause specifies that a SQL select statement should only return rows where aggregate values meet the specified conditions.
SQL GROUP BY
SQL GROUP BY Statement is used to arrange identical data into groups with the help of Aggregate functions.
SQL Server OUTPUT CLAUSE
The OUTPUT clause returns the values of each row that was affected by an INSERT, UPDATE or DELETE statements.
SQL Server Stored Procedure
A stored procedure is a group of SQL statements compiled into one unit for later use and can be used many times.
SQL Server ORDER BY
SQL ORDER BY keyword is used to sort the result set in ascending or descending order.
SQL CROSS JOIN
SQL CROSS JOIN returns a result set which is the number of rows in the first table multiplied by the number of rows in the second table if no WHERE clause is used along with CROSS JOIN
SQL SERVER WHERE
SQL WHERE clause is used to specify a condition while fetching the data from a tables.
SQL Server MAX
SQL Server MAX() function is an aggregate function that is used to find the Maximum or Largest value of a column .
SQL Server MIN
SQL Server MIN() function is an aggregate function that is used to find the smallest or minimum value of a column
SQL COUNT
SQL Server COUNT() function is an aggreagate function that returns the number of rows in a table . It sets the number of rows or non NULL column values.
SQL Server SUM
SQL Server SUM function is an aggregate that returns the sum of values for any column in a table.
SQL FULL OUTER JOIN
SQL FULL JOIN or FULL OUTER JOIN returns rows from both left and right tables, with the matching rows from both tables where available. If there is no match, the missing side will have null values.