Delete record from multiple tables using single query in SQL Server

kavithav

SOLVED CLOSED ACTIVE ANSWERED
User: kavithav
Posted: on Feb 19, 2018 07:09 AM
Forum: SQL Server
Answer: 1
Views: 2380

I have five tables and if i delete a record in gridview i need to delete all the records rleated to that using sql how can i do this.In these five tables tbl4 is the main table and that id in tbl4 is passed to all the remaining four tables and if i delete a record in gridview all the data related to id 123 should be deleted in remaining four tables how can i do this

select  * from Tbl1 where PName='123'
select  * from Tbl2 where PName='123'
select  * from Tbl3 where PName='123'
select  * from Tbl4 where ID='123'
select  * from Tbl5 where PName='123'

Download FREE API for Word, Excel and PDF in ASP.Net

nagaraju...

0 5

Reply
ANSWER
User: nagaraju60
Replied: on Feb 20, 2018 12:15 AM
Modified: on Feb 20, 2018 12:21 AM
Report

Dear @kavithav,

Please refer below article and use it as reference.

https://www.aspsnippets.com/Articles/Execute-multiple-SQL-Queries-in-one-Statement-using-C-and-VBNet.aspx

instead of selecting use delete query and change your query.

string query = "Delete tbl1 From tbl1 where PName=123;";
        query += "Delete tbl1 From tbl2 where PName=123;";
		 query += "Delete tbl3 From tbl3 where PName=123;";
		  query += "Delete tbl4 From tbl4 where ID=123;";
		   query += "Delete tbl5 From tbl5 where PName=123";

it might help you

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Delete record from multiple tables using single query in SQL Server

Company

Explore

Follow us

Contact Us