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

Explain the first normal form(1nf)?

1033

What is a field name?

975

How to verify a user name with sqlcmd tool?

1087

Describe in brief databases and sql server databases architecture.

1014

Why variables called the most powerful component of ssis?

1083

What are the different types of data sources in ssrs?

196

Explain filestream storage of sql server 2008?

1024

Why use “in” clause in sql server?

1076

What causes index fragmentation?

1000

Explain filtered indexes?

1006

Define union, union all, minus, intersect?

985

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1014

What is the return type of executeupdate ()?

909

Explain the rules for designing files and file groups in sql server?

994

What is a livelock?

973