Answer Posted / suhail qaiser

SELECT TOP Nth salary
FROM (
SELECT TOP N salary
FROM emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC

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

1080

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1127

---

when would you go for denormalization? : Sql server database administration

911

---

What are subquery and its properties?

1105

---

What are the types of user defined functions in sql server?

1100

---

Can two tables share the same primary key?

987

---

Tell me can we use custom code in ssrs?

1055

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

1012

---

What is the new security features added in sql server 2016? : sql server security

1165

---

difference between Clustered index and non clustered index ?

1039

---

Is sql server is free?

1017

---

Explain the microsoft sql server delete command?

1079

---

Explain go command in sql server?

1090

---

Can we use trigger new in before insert?

970

---

What is for xml in sql server?

1140

---