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 specify the collation for a character data type in ms sql server?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
Explain about protocol layer present in SQL server?
How to retrieve error messages using mssql_get_last_message()?
what is memory-optimized nonclustered indexes
How to concatenate two binary strings together?
What is enhanced database mirroring in sql server 2008?
What are different types of join?
What are filegroups in sql server?
What stored by the tempdb ? : sql server database administration
What is oltp (online transaction processing)?
Define candidate key, alternate key, and composite key.
Why use “nolock” in sql server?
What is Service Broker in sql server 2012?
What is normalization and its types?