Answer Posted / sumathy

Create Table 'Employee' with columns 'Emp_Name'
and 'Salary'. And, Insert some data.....

Cursor:
declare Cursor_Name cursor scroll
for select salary from Emploee order by salary desc
open Cursor_Name
fetch absolute 2 from Cursor_Name
deallocate Cursor_Name

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

1109

---

What are sql azure firewall rules?

106

---

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

966

---

What is replication and database mirroring?

1086

---

What is precedence constraint?

1035

---

Write a query for primary key constraint with identity key word?

1077

---

Can we perform backup restore operation on tempdb? : sql server database administration

1045

---

How we can refresh the view?

1158

---

List out some of the requirements to set up a sql server failover cluster?

1074

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1053

---

Do you know what are the differences between lost updates and uncommitted dependencies?

1136

---

Explain important index characteristics?

1076

---

What is table-valued sub query?

1026

---

How can you append an identity column to a temporary table?

1030

---

What are the different types of collation sensitivity?

1174

---