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 do you understand by triggers?

1 Answers  

---

What are the different ways you can create databases in sql server?

1 Answers  

---

What is difference between rownum and rowid?

1 Answers  

---

What happens if you are trying to access a schema not owned by you?

1 Answers  

---

Define right outer join?

1 Answers  

---

What is the temp table?

1 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

1 Answers  

---

List all the types of user-defined functions?

1 Answers  

---

Tell me the difference between clustered and non-clustered index?

1 Answers  

---

What is the default value of an integer data type in sql server 2005?

1 Answers  

---

How can I create a new template for import ? : sql server management studio

1 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---