How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 35611 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / zackziss
delete from c from child c inner join parent
on c.childid = parentid
| Is This Answer Correct ? | 2 Yes | 11 No |
Post New Answer View All Answers
Does view occupy space?
what is spatial nonclustered index
How raid can influence database performance?
What are the different types of subquery?
How to rebuild the master database?
How can we solve concurrency problems?
What is temporary table in sql server? Why we use temp table?
When should you use an instead of trigger?
What is standby servers? Explain types of standby servers.
How to enter binary string literals in ms sql server?
What is self contained sub query?
How to convert character strings into numeric values?
what is the difference between openrowset and openquery?
How do I create a trace in sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
