how to find number of columns in a table in sql server 2000 and 2005 also

16 Answers   Virtusa,

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

What does COMMIT command do?

0 Answers   Amdocs,

---

How can i Relate Tables in SSIS

0 Answers   HCL,

---

Which institute is best for SQL Server 2005 Training?

6 Answers  

---

Can you insert NULL in unique column?

0 Answers   MCN Solutions,

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---

What is difference between equi join and inner join?

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

What are the different types of indexes?

0 Answers   Blue Star,

---

What is difference between stored procedure and function?

3 Answers   L&T,

---