Answer Posted / anuj somvanshi

select salary from emp where rownum=n order by salary desc;

Disadvantages of the indexes?

1126

---

How to provide default values to stored procedure parameters?

1068

---

What is #temp and @table variable in SQL server?

1096

---

In which sql server version report builder introduced?

150

---

What is an active database?

1017

---

How many types of built in functions are there in sql server 2012?

926

---

Why truncate is ddl command?

1069

---

Tell me what is the stuff and how does it differ from the replace function?

983

---

How to read data in a table with "select" statements?

970

---

Which sql server is best?

999

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

925

---

Explain syntax for viewing trigger?

929

---

Do you know what are the ways available in sql server to execute sql statements?

1037

---

What are trace files?

964

---

What is the sql server agent?

1093

---