Why union all is faster than union?

0 Answers  

---

Which TCP/IP port does SQL Server run on?

2 Answers  

---

what is checksum in sql server.........???

0 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  

---

how can u get last observation in an unknown dataset ?

0 Answers   Genpact,

---

Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---

How to convert a table data in XML format in sql server?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

how can ur insert the emp table

3 Answers   Wipro,

---