Answer / manoj

Usually procedures are used when some action is to be
performed without retrun value.
Functions are used when some value is to be returned to the
calling enviornment.
You can not use procedure in the select statement however
functions can be used.

Answer / priya

can we use default value in unique key?

Answer / adil khan

procedure can only use in plsql not in sql. in other words
you can not use procedure in your select satatement. only
funtion can be used for example max(),min(),Avg() these all
are funtion not procedure.

What is transcation?Plz give One example?

2 Answers  

---

What is the temp table?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

How will u get 5 years back record?

5 Answers  

---

How do use Having,Group by,Group function in SQL?

0 Answers  

---

---

What do you mean by tablesample?

0 Answers  

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---

What is a collation in ms sql server?

0 Answers  

---

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

---

How to list all dsn entries on your local machine using odbc_data_source()?

0 Answers  

---

How do I view views in sql server?

0 Answers  

---

What are the differences between union, intersect, and minus operators?

0 Answers  

---