What is row_number()?

0 Answers  

---

How can I check if a view exists in a sql server database?

0 Answers  

---

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

---

Explain what are commit and rollback in sql?

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??

8 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

What are the lambda triggers?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,

---