Technical Article

Generate Delete Stored Procedure

This procedure will generate a delete stored procedure against a provided table and column name in your database.  It will search for foriegn key constraints and create a delete statement for each one found in the database.  The procedure has three parameters:@table_name nvarchar(128) = the name of the source table@column_name nvarchar(128) = the name of […]

You rated this post out of 5. Change rating

2002-04-22

274 reads

Blogs

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

FabCon 2025 Recap

By

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...

Privacy Policy

By

We value your privacy. This policy explains what personal data we collect and why. What...

Read the latest Blogs

Forums

why cant i get rid of extra dataset

By stan

hi i never used shared datasets before in ssrs.   i created a dataset  called...

Distinct values using string_agg

By jagjitsingh

Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...

Refactoring a DELETE query using NOT EXISTS — need expert feedback

By abdalah.mehdoini

Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...

Visit the forum

Question of the Day

Importing Flat Files

What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?

See possible answers