Answer Posted / sujitha

For Example TableName: Employee. Employee Have The
Following Fields.
Emp_No ( Identity Value)
Emp_Name
Designation



Select Top 1 * From Employee Where Emp_No Not in(Select
Top 24 Emp_No From Employee)

How to get a list of columns in a view using the "sp_help" stored procedure?

1088

---

What is check constraint in sql server?

1047

---

Explain table valued parameters in sql server? Why tvp used?

1067

---

What are different types of views?

985

---

What is rolap and its advantage? : sql server analysis services, ssas

1329

---

What do you understand by check constraint in sql server?

1015

---

Explain the properties of a relational table?

1075

---

What is enhanced database mirroring in sql server 2008?

1033

---

How to add a new dsn with the odbc driver for sql server?

1112

---

What is normalization of database? What are its benefits?

1070

---

What is efficiency data?

1002

---

List the different types of joins?

1057

---

Where cross join is used?

1028

---

What is stretch database in sql server?

1120

---

What is the difference in accessing db between sql server vs sql azure?

174

---