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 the maximum length of an alert name?

0 Answers  

---

What is tablesample?

0 Answers  

---

What is checkpoint process in the sql server?

0 Answers  

---

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

---

List out the differences between the clustered index and non-clustered index in sql server?

0 Answers  

---

What is dbcc updateusage?

0 Answers  

---

Is truncate autocommit?

0 Answers  

---

Do you know clustered and non-clustered index?

0 Answers  

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

---

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

---

What are different types of join?

0 Answers  

---