How to delete a record from to table in database using ASP?

E

eren_greenlady

New member
I have two table that are tbl_EmpDetail and tbl_User. these two contains same data. How to delete the records in both table at the same time?

Please Help..
To Jason, Thanks. :)
 
command.CommandText = "delete from tbl_EmpDetail; delete from tbl_User";

I am not sure about doing that in one SQL statement, but you can always use multi-step SQL commands. I know SQL Server supports this.
 
Back
Top