How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 35595 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / tester
Hi vaishali have u executed the query it is not working
| Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
What is a scheduled job or what is a scheduled task?
How can you append an identity column to a temporary table?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
List the ways in which dynamic sql can be executed?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How to provide default values to function parameters?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is sql or structured query language?
Explain “row_number()” in sql server with an example?
How can I check that whether automatic statistic update is enabled or not?
Why and when do stored procedure recompile?
What are the different subsets of sql?
What is subquery? Explain the properties of a subquery?
Can we do dml on views?
