Schedule a Job in SQL
The SQL Server Agent job is the specified action or series of actions that the SQL Server Agent will execute at any specific date time.
Home » SQL Database »
SQL Database
SQL Server Tutorials By Pradeep Raturi- This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .You will find out a step-by-step
SQL LIKE CLAUSE
The SQLÂ LIKE clause is used to match a value to a similar values using wildcard operators. It is used with Where Clause.
There are two type of wildcards used in conjunction with the LIKE operator.
The percent sign (%) that is used to represent zero , one, or multiple characters.
The underscore (_) that is used to represent a single number or character.
How to display Cumulative total in SQL ?
A Cumulative total or running total refers to the sum of values in all cells of a column that precedes the next cell in that particular column
What is Correlated Subquery in SQL?
A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer queryÂ
A correlated subquery always depends on outer query for its value. Because of this dependency, a correlated subquery cannot be executed independently as a simple subquery .
What is SubQuery in SQL ?
A Subquery is a query within another query. The outer query is called as main query and inner query is called as sub query.
SQL UNION ALL
SQL UNION ALL operator is used to combine the result sets of two or more select statements .
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 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 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.