How to list all columns in a table using odbc_columns()?

0 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

What is a trigger? Why we need it?

0 Answers   Accenture,

---

What are the steps to process a single select statement?

0 Answers  

---

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---

What is faster join or union?

0 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

What is advantage data architect?

0 Answers  

---

Can some one please help with a query which will take only max value of a column in a join.

2 Answers  

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---