adspace


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 connect php with different port numbers?

1193


How to enter binary string literals in ms sql server?

1248


How to rebuild the master database?

1170


What is the difference between upgrade and migration in sql server?

1186


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1301


Disadvantages of the indexes?

1228


What is the primary use of the model database?

1152


Is it possible to have clustered index on separate drive from original table location?

1042


How can you append an identity column to a temporary table?

1072


How do I create a trace in sql server?

1122


Equi join and non equi join is possible with sql server?

1136


Why use identity in sql server?

1205


How do I find the sql server version?

1107


What kind of problems occurs if we do not implement proper locking strategy?

1504


What is a view in sql?

1044