What is the native system stored procedure to execute a command against all databases?

0 Answers  

---

How to define and use table alias names in ms sql server?

0 Answers  

---

Why use “pivot” in sql server?

0 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

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,

---

How do I start sql server?

0 Answers  

---

How to truncate a table first before running a package?

1 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---

How to add a new dsn with the odbc driver for sql server?

0 Answers  

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 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  

---

Define Joins?

0 Answers   HCL,

---