How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  

---

Can binary strings be used in arithmetical operations?

0 Answers  

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  

---

What is store procedure? How do they work?

0 Answers  

---

What is the significance of null value and why should we avoid permitting null values?

0 Answers  

---

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

---

What happens to a trigger with multiple affected rows?

0 Answers  

---

What is #table in sql server?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What is a fill factor?

0 Answers  

---