How to download microsoft sql server 2005 express edition?

0 Answers  

---

What is indexing a document?

0 Answers  

---

What is data mart? : sql server analysis services, ssas

0 Answers  

---

What xml support does the sql server extend?

0 Answers  

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

How to verify a user name with sqlcmd tool?

0 Answers  

---

What happens when converting big values to numeric data types?

0 Answers  

---

What is resource governor?

0 Answers  

---

Explain timestamp datatype?

0 Answers  

---

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  

---

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---