Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Delete record efficiently. (sp_CheckAndDelete )

By Dinesh Priyankara,

The sp_CheckAndDelete stored procedure specially created for handling process of data deleting efficiently in MS SQL Server 2000 tables, as it is too difficult to handle this process when dependants exist for record to be deleted. When the deleting process is done with sp_CheckAndDelete stored procedure, you will be informed the status of the process whether it is successful or not.
The table involves in the process must have a primary key.

Total article views: 173 | Views in the last 30 days: 1
 
Related Articles
FORUM

Delete process

Deleting lorge amounts of data

FORUM

ETL Process taking a while to execute

ETL process delete statment taking a while

FORUM

Find who/process that deleted records

How to find who deleted records.

FORUM

Deleting Table

Deleting

FORUM

delete table

delete

Tags
t-sql    
 
Contribute