what is physical sort data and logical sort data in index?

2 Answers  

---

Difference between server.transfer and server.execute method?

2 Answers  

---

How to see existing views in ms sql server?

0 Answers  

---

How to retrieve field values using mssql_result()?

0 Answers  

---

What are the default system databases in sql server 2000?

0 Answers  

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

---

What is the difference between varchar and nvarchar types?

1 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

in how many ways we can use count()

2 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---