How do you rebuild an identity column?

0 Answers  

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

What is the order in which the sql query is executed?

0 Answers  

---

What is a fill factor?

0 Answers  

---

How to get number of days in a given year?

4 Answers   ADP,

---

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

What is data source view or dsv? : sql server analysis services, ssas

0 Answers  

---

What is a sql join?

0 Answers  

---

What is a database in ms sql server?

0 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

Magic Tables ?

2 Answers   Thomson Reuters,

---

How do I make a resultset scrollable?

0 Answers  

---