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.

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

---

Is sql server is free?

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

How can you find out which stored procedures are recompiling?

0 Answers  

---

What the different components in replication and what is their use?

0 Answers  

---

How do I debug a stored procedure in sql server?

0 Answers  

---

Can you leave a union at any time?

0 Answers  

---

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

0 Answers   Amdocs, Apps Associates,

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

What is the server name for sql management studio?

0 Answers  

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

0 Answers  

---