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.

 

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.