Answer / Arvind Kumar Pandey

No, you cannot break up a UNION statement. All SELECT statements within a UNION must have the same number and type of columns.

What is 2nf example?

1 Answers  

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

1 Answers  

---

Explain the new features of SQL server 2000?

1 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1 Answers  

---

How to loop through the result set with @@fetch_status?

1 Answers  

---

Where are sql server user names and passwords stored in sql server?

1 Answers  

---

Can you pass expressions to stored procedure parameters?

1 Answers  

---

What is row_number function?

1 Answers  

---

can you any body tell me the how to decrease the logfile

4 Answers  

---

What are subqueries in sql server?

1 Answers  

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

1 Answers  

---

What are the common performance issues in sql server?

1 Answers  

---