delete from c from child c inner join parent on c.childid = parentid

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

Question Posted / zackziss

Answer Posted / zackziss

delete from c from child c inner join parent
on c.childid = parentid

Is This Answer Correct ?

2 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Explain steps of normalization?

1064

Where views are stored in sql server?

1030

How to insert new line characters into strings?

1034

What is resource db in sql server?

1056

what is an extended stored procedure? : Sql server database administration

1109

How to implement service broker?

1070

Can we use where and having clause together?

1097

What are the difference between “where” and “having” clause in sql server?

1131

what are the different ways to return the rowcount of a table?

1050

Does transparent data encryption provide encryption when transmitting data across the network?

1099

what is dbcc? : Sql server database administration

1078

Explain an automatic checkpoint

1015

Can a table have 2 foreign keys?

956

List all the types of user-defined functions?

1182

define and explain the differences between clustered and non-clustered indexes.

1252