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

What are the different types of backups avaialabe in sql server 2005?

1013

What is candidate key with example?

975

Explain Geography datatype in SQL Server

1124

What are policy management terms?

981

What are the advantages of mirroring?

989

What is bit data type? What's the information that can be stored inside a bit column?

913

Explain primary key?

953

What is inline table-value user-defined function?

1105

Explain a checkpoint?

1026

How to use user defined functions in expressions?

1082

What is t-sql script to take database offline – take database online.

1079

In what sequence sql statement is processed?

1006

What is transaction server explicit transaction?

1028

List all types of constraints in sql server?

1020

What are the various editions of sql server 2017 that are available in the market?

889