" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

SQL Server: Restrict the duplicate insertion of records to the database using Store Procedure

Posted on November 24th, 2015 by Rasmita Mohanty

There are several ways we can avoid duplicate record insertion in the database using various programming languages. But, it doesnt have to be from programs always we can avoid duplicate insertion of records from the database too.   Here I am going to explain one of the methods by which we can avoid duplicate record insertion in the SQL Server database […]

Find Stored Procedure (s)/Function(s) related to a Table(s) in Database

Posted on November 24th, 2015 by Damodaranaidu Betha

Sometime we need to know what are the stored procedures/functions that are using a particular table in a huge database. The following queries list all the stored procedures/functions which are currently using the table. SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE ‘%Employee%’ GO –Searching for Empoloyee table and RateChangeDate column together SELECT Name FROM sys.procedures […]