Answer Posted / prakash

magic table are thouse on which we manuclate on data

Explain about local stored procedure?

1026

---

What is correlated subquery in sql server?

1120

---

How to retrieve field values using mssql_result()?

1408

---

What to perform pattern match with the like operator?

928

---

Explain index in sql server?

1061

---

How to fine-tune reports?

279

---

What are the differences between local and global temporary tables?

1124

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2115

---

How to change the ownership of a schema in ms sql server?

1252

---

How to loop through result set objects using odbc_fetch_row()?

1039

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1224

---

How exceptions can be handled in sql server programming?

1068

---

Explain transaction server explicit transaction?

968

---

What is the command dbcc checkdb used for?

1067

---

what's the difference between a primary key and a unique key? : Sql server database administration

986

---