Why and when do stored procedure recompile?

0 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

Explain time data type in sal server 2008?

0 Answers  

---

What stored by the tempdb ? : sql server database administration

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

What are a scheduled jobs?

0 Answers  

---

Explain collation?

0 Answers  

---

Explain what is cte (common table expression)?

0 Answers  

---

What is coalesce and check constraint in sql server?

0 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---