Answer Posted / ajay (esd)

Please ignore my above answer

select * from tablename where sno between 4 and 8


Ajay

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1064

---

how to avoid cursors? : Sql server database administration

904

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2443

---

What is nonclustered index on computed columns?

905

---

What are the advantages of sql stored procedure?

1015

---

Write a sql query to sort on different column name according to the parameters passed in the function?

852

---

What is table join?

1067

---

When cursors are useful?

1037

---

How do I find sql server instance name?

914

---

List the advantages of using stored procedures?

997

---

How is sql used in sql server?

941

---

What do you understand by the data quality services in sql server?

900

---

What do you need to connect php to sql server?

1038

---

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

857

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1008

---