Answer Posted / krishna evsg

With help of temporary tables , we can do it made easy

create table #temp_ParentIDs
(
ID int
)
GO

Insert into #temp_ParentIDs
(ID)
select Parent_id from child_tab
GO

delete from Child_tab
GO

delete from parent_tab where parent_Id In(select * from
#temp_ParentIDs)
GO

Give a example to search fr a string in all stored procedure in sql server.

909

---

what is a mixed extent? : Sql server administration

1022

---

What is used to replicate sessions between instances in coldfusion clusters?

1014

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1059

---

What is query processing?

880

---

How to rebuild indexes with alter index ... Rebuild?

1030

---

Explain what is dbcc?

961

---

Which rendering formats are affected by the pagesize properties?

134

---

What is query optimization process?

937

---

can a database be shrunk with users active? : Sql server administration

950

---

Why should one not prefix user stored procedures with ‘sp_’?

984

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

894

---

What do you understand by integration services in sql server?

919

---

How do I connect to sql server database?

949

---

when you create a database how is it stored? : Sql server database administration

939

---