How to write query to Delete the records in child table
and corresponding records in parent table
Answers were Sorted based on User's Feedback
Answer / vaishali
delete from child_table, parent_table where
child_table.parent_id=parent_table.parent_id
| Is This Answer Correct ? | 14 Yes | 26 No |
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Can we perform backup restore operation on tempdb?
what is denormalization and when would you go for it? : Sql server database administration
what are the joins,primary key,foriegn key, candidate key, super key and expain them?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is implicit cursors?
What is full form of XP ?
42 Answers Cap Gemini, Infosys, Microsoft, Oracle, Reliance,
Explain the commands in sql server?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How will u get 5 years back record?
What is the diffrence between update_one and auto_fix?
What are the 3 types of schema?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)