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)

Explain Geometry datatype in sql server 2008 with example

919

---

Explain how dts is used to extract, transform and consolidate data?

938

---

What sql server means?

909

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

956

---

What is the function of inner join?

1004

---

how many clustered indexes can be created on a table? : Sql server database administration

1066

---

What is SQL Server?

1148

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

882

---

How connect excel to sql server?

929

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2465

---

Can an automatic recovery be initiated by a user?

941

---

What happens if the update subquery returns no rows in ms sql server?

1073

---

How check triggers in sql server?

914

---

How do I schedule a sql server profiler trace?

913

---

How to receive output values from stored procedures?

1054

---