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
- 34810 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
What are the types of dml?
Tell me what is de-normalization and what are some of the examples of it?
Difference between DELETE and TRUNCATE?
What are trace flags and mention a few common trace flags used with sql server?
What is dbcc?
List out the differences between global and local temp tables in sql server?
What are the differences between sql server and mysql.
Explain what is cte (common table expression)?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Explain the collation?
What is query optimization process?
How do you trace the traffic hitting a sql server?
What is trigger in salesforce?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Explain query editor regions
