Answer Posted / aditya

select *from <table name>where sal<20

What is a covering index?

921

---

What are the advantages of using stored procedures?

892

---

Can we use max in where clause?

882

---

Do you know what are acid properties?

1018

---

What is the difference between for auto and for nested?

934

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

892

---

Where to find ntwdblib.dll version 2000.80.194.0?

922

---

How to find index size for each index on table?

963

---

What structure can you implement for the database to speed up table reads?

1157

---

Explain use of expression builder.

953

---

How do I create an extended event in sql server?

906

---

How to disconnect from a sql server using mssql_close()?

1026

---

Define right outer join in sql server joins?

983

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1019

---

Where the sql logs gets stored?

936

---