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


Please Help Members By Posting Answers For Below Questions

How to specify the collation for a character data type in ms sql server?

737


Is it true that rules do not apply to data already existing in a database at the time the rule is created?

743


Explain about protocol layer present in SQL server?

779


How to retrieve error messages using mssql_get_last_message()?

724


what is memory-optimized nonclustered indexes

728






How to concatenate two binary strings together?

783


What is enhanced database mirroring in sql server 2008?

669


What are different types of join?

948


What are filegroups in sql server?

771


What stored by the tempdb ? : sql server database administration

757


What is oltp (online transaction processing)?

744


Define candidate key, alternate key, and composite key.

682


Why use “nolock” in sql server?

722


What is Service Broker in sql server 2012?

771


What is normalization and its types?

743