Interested to Buy Any Domain ? << Click Here >> for more details...
How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 34821 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / krishna evsg
With help of temporary tables , we can do it made easy
create table #temp_ParentIDs
(
ID int
)
GO
Insert into #temp_ParentIDs
(ID)
select Parent_id from child_tab
GO
delete from Child_tab
GO
delete from parent_tab where parent_Id In(select * from
#temp_ParentIDs)
GO
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to delete an existing database user?
What is transactional replication?
How to restore performance issues and how to check?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What are the differences between ms sql server & oracle?
What is an index in sql?
Can you pass expressions to function parameters?
How do I open a .db file?
What is wide table?
What are different types of subquery?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
what is a self join? : Sql server database administration
What Is Rdbms?
How do I get to sql server configuration manager?
What is t-sql script to take database offline – take database online.
