Answer Posted / veeresh kethari

with Topsal (EmpID,Ename,Sal,Dno,Topsal) as
(select *,row_number() over(order by sal) Topsal from emp)
select top 2 EmpID,Ename,Sal,Dno from Topsal order by sal desc

What is advantage data architect?

925

---

how many no of arguments can be passed in procedures and functions

5566

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

933

---

What is filtered index?

1096

---

How to search for a string in all stored procedure in sql server?

999

---

Explain log shipping and mention its advantages.

1044

---

What are the different types of normalization?

1167

---

Explain about system stored procedure?

1035

---

how can you attach more than 20 ldf files in sql server

2003

---

How to retrieve error messages using odbc_errormsg()?

1059

---

What are pessimistic lock and optimistic lock?

1079

---

What is bit data type? What's the information that can be stored inside a bit column?

922

---

Is it true, that there is no difference between a rule and a check constraint?

1058

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1162

---

What is the difference between a primary key and a unique key? Are they the same?

1077

---