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

How to modify an existing user defined function?

1031

How sql server executes a statement with nested subqueries?

957

How to list all columns in a table using odbc_columns()?

934

What do you understand by the data quality services in sql server?

899

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

962

What is CTE in SQL

874

What is plan freezing?

907

What happens if null values are involved in arithmetic operations?

961

What is conditional split?

986

How do I find information about the install locations for the various instances running on a computer?

1029

What is proper subset of candidate key?

944

What is report snapshot?

142

Difference between report and query parameter.

1022

What are various ways to enhance the ssrs report?

920

How to select some specific rows from a table in ms sql server?

960