How to write query to Delete the records in child table
and corresponding records in parent table
Answer Posted / sanjay
delete details from details inner join master on
details.keyid=master.keyid
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What's the information that can be stored inside a bit column?
Distinguish between nested subquery and correlated subquery?
How do I start and stop sql server?
What gets stored inside msdb database?
How to execute multiple stored procedures at one time in sql server?
What are the restrictions that views have to follow? : SQL Server Architecture
What is rtm version in sql server?
Can you explain the disadvantages/limitation of the cursor?
What are basics of policy management?
What is cached report?
Tell me what are cursors and when they are useful?
What is clustered primary key?
What is the significance of null value and why should we avoid permitting null values?
What is the order by used for?