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.

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---

What are the differences between having and where clause.

0 Answers  

---

Which tcl commands are available on the sql server?

0 Answers  

---

What’s the use of custom fields in report?

0 Answers  

---

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  

---

How to create function with parameter in sql server?

0 Answers  

---

How to provide Security for package?

1 Answers   Convergys,

---

Selet all the data from table where last name is n of employee

2 Answers  

---

How many types of Outer Joins?What are they?

1 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

Explain couple pf features of SQL server

2 Answers  

---