SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag delete Rss

Search for any content tagged delete

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)

Add a script

   Items 1 to 5 of 5   

Generate MERGE statements with Table data

A stored procedure that produces a MERGE statement for a given table containing a VALUES clause for all rows, useful for migrating static data between environments.  Read more...
By Daniel Nolan 2014/01/07 | Source: SQLServerCentral.com | Category: generate
Rating: |  Discuss |   Briefcase | 5,163 reads

Easily delete database objects

The stored procedure sp_DropDatabaseObject is designed to easily drop a variety of database objects with extensive feedback to the user  Read more...
Rating: |  Discuss |   Briefcase | 1,434 reads

Truncate Referenced Table

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.  Read more...
By Chris Morton 2009/01/19 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,279 reads

Deleting old files (with/without archive bit)

A hopefully useful script to delete old files, not just backups, and make use of the archive bit.  Read more...
By Gaby Abed 2009/01/01 | Source: SQLServerCentral.com | Category: archiving data
Rating: |  Discuss |   Briefcase | 1,945 reads

Delete records in all related tables

Used to generate Select/Delete scripts. It does NOT run them. You need to copy the output of this script to a new window and run it manually.   Read more...
By David Jackson 2008/08/06 | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 531 reads
   Items 1 to 5 of 5