How to write query to Delete the records in child table
and corresponding records in parent table
Answer Posted / vaishali
delete from child_table, parent_table where
child_table.parent_id=parent_table.parent_id
| Is This Answer Correct ? | 14 Yes | 26 No |
Post New Answer View All Answers
Is it possible to update the views? If yes, how, if not, why?
What is temporary stored procedure?
When I run the sql server 2000 setup, it just hangs. What do I do?
Explain index in sql server?
What is the server name in sql server?
How to generate create view script on an existing view?
What are different types of data sources?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Is the log file is a part of file group?
What are various aggregate functions that are available?
Can you use order by when defining a view?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is built-in function?
Do you know what are the reporting services components?
Explain the different index configurations a table can have?