Answer Posted / anuj somvanshi

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

What are logical database components? : SQL Server Architecture

985

---

What are recommended options to be used while using db mirroring? : sql server database administration

1102

---

What is triggers in ms sql server?

1077

---

Explain go command in sql server?

992

---

How we can compare two database data?

896

---

What are the ways available in sql server to execute sql statements?

1070

---

If a stored procedure is taking a table data type, how it looks?

6387

---

How to convert character strings into numeric values?

1063

---

what is dbcc? : Sql server database administration

996

---

Explain about unique identifier data type in sql server?

883

---

What are the indexes in sql server?

1068

---

How many columns can exist together per table?

1119

---

How do I debug a stored procedure in sql server?

1055

---

What happens to a trigger with multiple affected rows?

899

---

Explain how dts is used to extract, transform and consolidate data?

968

---