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
How to list all login names on the ms sql server?
What is a non clustered primary key?
When cursors are useful?
What happens on checkpoint?
What is the difference between sdf and mdf?
Which are new data types introduced in sql server 2008?
What is difference between index and primary key?
what is a deadlock? : Sql server database administration
Can group functions be used in the order by clause in ms sql server?
How self join is different from outer join?
How to locate and take substrings with charindex() and substring() functions?
What is cube dimension? : sql server analysis services, ssas
How each E-R model constructs can be mapped to the relational model?
What is the use of floor function in sql server?
What is the difference between cartesian product and cross join?