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)

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1031

---

What is a View ? Can we insert, Update and delete a view?

996

---

What is cursors?

1192

---

What is the purpose of the tempdb database?

1001

---

Explain about Normalization?

1069

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

981

---

What is service broker?

1006

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1049

---

How does index makes search faster?

980

---

How to execute a sql statement using odbc_exec()?

1148

---

What is the data tier application?

169

---

What is the difference between varchar and varchar(max) datatypes?

1078

---

How do I create a stored procedure in sql server?

1038

---

How do I find sql server instance name?

965

---

What is normalization and its types?

1040

---