delete details from details inner join master on details.keyid=master.ke

How to write query to Delete the records in child table
and corresponding records in parent table

Question Posted / sanjay

Answer Posted / sanjay

delete details from details inner join master on
details.keyid=master.keyid

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of user-defined functions over stored procedures in sql server?

1019

How many types of functions are there in sql server?

921

Does any body please help me what question's have asked for SSRS in the interview?

2134

What is an expression in ms sql server?

1056

What are scheduled tasks in sql server?

1063

What are different types of subquery?

1217

Give a example to search fr a string in all stored procedure in sql server.

964

How will you decide the active and passive nodes?

1114

What Are the Main Features of SQL Azure?

117

How to replace the Query Result 'Null Value' with a text ?

1017

Can I use sql azure as a backup with log shipping or database mirroring?

156

What is xdr?

975

Why use update_statistics command in sql server?

1031

What is Cross Join and in which scenario do we use Cross Join?

1003

Explain something about security and SQL Azure?

134