Answer Posted / vikram k mahapatra

It return Int datatype

What does the automatic recovery do?

786

---

How do you use a subquery to find records that exist in one table and do not exist in another?

741

---

Are semicolons required at the end of sql statements in sql server 2005?

735

---

What are the advantages of user defined function?

663

---

What is a field name?

706

---

---

Explain raiserror in sql server?

753

---

Which table keeps the locking information?

695

---

Explain rdbms?

753

---

Why olap is used?

724

---

Explain what is lock escalation?

766

---

How to generate create view script on an existing view?

742

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

766

---

How do I view a trc file?

682

---

Explain about remote stored procedure?

772

---

What is rank function?

787

---