Answer Posted / ajay (esd)

Please ignore my above answer

select * from tablename where sno between 4 and 8


Ajay

How would you use user_constraints table in DB?

1002

---

How do I get to sql server configuration manager?

1003

---

What is xdr?

985

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

934

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1035

---

Explain syntax for viewing, dropping and disabling triggers?

947

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

901

---

What are the different types of subquery?

1147

---

How many clustered indexes there can be on table ?

1024

---

What are the essential components of sql server service broker?

1016

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1076

---

What are the system database in sql server 2005?

1040

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

943

---

What protocol does sql server use?

936

---

What is table-valued sub query?

957

---