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

Do you know what are acid properties?

1086

How to convert character strings into numeric values?

1102

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

911

Define outer join?

1004

What are the advantages of log shipping?

998

What is SQL Azure Data sync?

121

What is dimension table? : sql server analysis services, ssas

1024

Show Practically Sql Server Views are updatable?

1128

How to call a function from a stored procedure in SQL Server ?

1034

List the various tools available for performance tuning?

890

What is merge statement?

1086

How to recreate an existing index in ms sql server?

1063

Can we add a cpu to sql server?

1019

How to create a testing table with test data in ms sql server?

1088

What is report snapshot?

163