How to check how many Stored Procedures had called a particular Procedure in SQL
CREATE PROCEDURE SP1 AS BEGIN SELECT GETDATE() AS DATE END CREATE PROCEDURE SP2 AS BEGIN EXEC SP1 END CREATE PROCEDURE SP3 AS BEGIN EXEC SP1... Read more
Tag: sql interview question
SQL – Rollback a transactions to a savepoint
I Assume that you have a basic idea of Transactions. If not go through What are Transactions in SQL Server first. So we can do... Read more
SQL – Interview Questions
Table of Content : here Goto Category SQL : here Q. You have the below SQL Code in your application. Example: DECLARE @TABLE TABLE(col INT)... Read more