Interested to Buy Any Domain ? << Click Here >> for more details...
How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 35349 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / chaitanya
***********
Delete from P_table where P_Id=C_Id
***********
This is only aplicable if you have defined the foreign key
in the child table with the constraint on Delete Cascade.
Else you will get a Integration error.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is join query?
What is format parameter in ssrs?
What is a partition function in sql server?
What are the different authentication modes in sql server? How can it be changed?
How to round a numeric value to a specific precision?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Explain about temporary stored procedure?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Tell me what is a linked server?
What are the rendering extensions of ssrs?
Do you know what are the reporting services components?
What stored by the msdb?
What do you mean by normalisation?
How do you improve the performance of a SQL Azure Database?
What the different topologies in which replication can be configured?
