Answer Posted / rohit kumar singh

update & delete are two magic tables.
(a)update
insert and update
(b)delete

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

563

---

What are the difference between “where” and “having” clause in sql server?

589

---

Can you force a query to use a specific index?

535

---

Can you use order by when defining a view?

575

---

Some queries related to SQL

592

---

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

567

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2182

---

Explain what are various ways to enhance the ssrs report?

572

---

What is an indexing strategy?

538

---

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

551

---

Can group functions be used in the order by clause in ms sql server?

595

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

544

---

How can sql server instances be hidden?

528

---

How to update muliple row in single query?

613

---

What is a result set object returned by mssql_query()?

580

---