Answer Posted / vijay dev arya

select salary from employee where salary>(select max
(salary) from employee)

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

986

---

What is the difference between row_number and dense_rank?

847

---

Why use “nolock” in sql server?

1012

---

do you know how to configure db2 side of the application? : Sql server database administration

1008

---

When columns are added to existing tables, what do they initially contain?

1000

---

Do you know how to store and query spatial data?

1005

---

How will you optimize a stored procedure optimization?

988

---

how to define testing of network layers? : Sql server database administration

937

---

What are functions in the sql server?

1159

---

What is a non-clustered index?

965

---

What is @@error in sql?

1035

---

What are different types of raid configurations? : SQL Server Architecture

1027

---

What is the latest version of microsoft sql server?

1006

---

Is it possible to update the views? If yes, how, if not, why?

986

---

How many servers can we create in a single subscription?

158

---