Answer Posted / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

What are the different types of upgrades that can be performed in sql server?

1212

---

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

1046

---

How to create a large table with random data for index testing in ms sql server?

1067

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1246

---

How do I find the sql server instance name?

1012

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

1049

---

What are the steps you should follow to start sql server in single-user mode?

949

---

How to use order by with union operators in ms sql server?

1063

---

Explain the ways to controlling cursor behavior?

967

---

Define magic tables in sql server?

1116

---

What is filter index?

993

---

Explain what is the difference between union and union all?

1070

---

What is difference between delete and truncate commands?

1170

---

What are the restrictions applicable while creating views? : SQL Server Architecture

1081

---

your distribution database is full what will u do

2217

---