How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 32986 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 is the difference between createstatement and preparedstatement?
How to enter date and time literals in ms sql server?
What is the difference between grant and with grant while giving permissions to the user?
How to use wildcard characters in like operations in ms sql server?
What is the importance of concurrency control?
How to rename databases in ms sql server?
How to replace null values in expressions using isnull()?
What is the purpose of optimization?
What is a result set object returned by mssql_query()?
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
List some major differences between triggers and stored procedures?
What purpose does the model database server?
How to add additional conditions in SQL?
what exactly sql injuction.how to overcome.....
Explain different types of lock modes in sql server 2000?
