How to write query to Delete the records in child table and corresponding records in parent table

11 Answers   Semantic Space,

---

Do you know the cursor types?

0 Answers  

---

What is an extended Stored Procedure?

1 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

Can you give an example of Stored Procedure?

4 Answers   Wipro,

---

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

What is merge join?

0 Answers  

---

What is truncate table?

0 Answers  

---

How to get the query of a table in sql server?

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

What is change tracking in sql server?

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---