If you can live with a two-step-delete, then the following will give the desired results. DECLARE @x XML SELECT @x = ' Mitesh R E1 E2 E3 ...

This script is export gridview data in excel file...

This script demonstrates how to backup a database to a network share (i.e. UNC path). This script is written to take a full database backup for demonstration purposes. However, you can customize this script to suit your backup strategy (differential/log...

This script helps restore a database from a backup file lying on a network share (i.e. UNC path). Please customize this script for your configuration. For demonstration purposes, this script has been written to perform a complete restore of the database...

We are mostly creating primary key on column while creating tables, But sometime we also need to have it after creating table or on existing table as per need, So i am sharing the script to add primary key on table....

This script may help to list all windows services installed on machine....

We all know the way to create foreign key on column, and we are using UI to create it mostly instead of script. Did you used script to add foreign key? ...

Script to take database backup, compress it and upload to SFTP...

This script connects to a SQL Server instance and enumerates all the databases available in it....

If we are redirecting from one page to another page, using Response.Redirect will send "302" status code, this results in SEO issues. To improve SEO performance, sending "301" status code will be helpful. In .NET 4.0 framework Response.RedirectPermanent...