In this post, you will learn some important SQL queries 2018. Before we get started if you want to know how to optimize SQL queries, please go through the following article: SQL Query Optimize.

How can we know how many stored procedures have executed so far and how many times?

How to Kill All the Processes for Any Database?

How Many Temporary Tables are Created So Far in SQL Server?

How to Validate Email Address in SQL Server?

How to Allow Only Alphabets in Column?

How to Count Week Days Between Two Dates?

How to Write Case Statement in WHERE Clause?

How to Get Random Records from Table?

How to find the longest running query in SQL Server with Execution Plan?

How to Introduce Time Delay Between Two TSQL Commands?

How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?

How to find all the queries in SQL Server? Can you find it with the help of DMV?

Write a script to list all the stored procedure modified in last 7 days.

Write a query to retrieve Second (or Nth) highest salary of an employee from a table.

Some Important SQL Queries 2018

The article was published on April 1, 2018 @ 10:30 AM

Leave a Comment