Answer / pushpa

datediff(mm,getdate(),'9/6/1980')

Answer / jayesh l lolariya

select datediff(dd,'03-03-2008',getdate()) as dataDiff

what are the different type of sql's statements ? : Sql dba

0 Answers  

---

Is ms sql is free?

0 Answers  

---

How do I know if I have sql express or standard?

0 Answers  

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

---

Can we group by two columns in sql?

0 Answers  

---

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

---

Can we use update in sql function?

0 Answers  

---

Mention what is the plv (pl/vision) package offers?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

What is parameter substitution in sql?

0 Answers  

---

How do I save a sql query?

0 Answers  

---