Answer Posted / m.s.patil

select max(sal) from t1 where sal not in (27777);

27777 is max salary in table

What is NOT NULL Constraint in sql server 2012?

1005

---

Explain trigger and its types?

1071

---

What are translations and its use? : sql server analysis services, ssas

1046

---

Do you know what is a with(nolock)?

1063

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1030

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

952

---

List out different types of normalizations in sql server and explain each of them?

935

---

What do you understand by physical_only option in dbcc checkdb?

982

---

Tell me what is use of except clause? How it differs from not in clause?

962

---

What is self join in sql server joins?

1067

---

How to define the name and server for a new dsn?

1124

---

What do you think of this implementation? Can this be implemented better?

945

---

What is the importance of a recovery model?

1052

---

What is data source object?

1008

---

How can I tell if sql server is 32 or 64 bit?

970

---