Answer Posted / samba shiva reddy . m

sorry the last post was not correct.

yes we can call stored procedure in User defined function.
1.Stored procedures are pree compiled and functions are not pree compiled it will execute at run time.
2.Functions cannot affect the state of the database which means we cannot perform insert,delete,update and create operations on the database.
Stored Procedures can affect the state of the database by using insert,delete,update and create operations.
3.Procedure can return zero or n values whereas function can return one value which is mandatory.
4.Procedures can have input,output parameters for it whereas functions can have only input parameters.
5.Functions can be called from procedures and in select statement and whereas procedures cannot be called from function or select statement.
6.A Function returns 1 value only. Procedure can return
multiple values (max 1024).
7. Stored procedure returns always integer value by default
zero. Whereas function returns type could be scalar or
table or table values.

What are the system database in sql server 2005?

1096

---

How to include date and time values in sql statements?

1140

---

What is SQL Azure Fabric?

112

---

Explain system scalar functions?

1043

---

Explain linked server in sql?

1292

---

Explain difference between cross join and full outer join?

1064

---

Can you edit the .rdl code associated with a linked report?

168

---

what is the main function of a query parameter?

155

---

What type of locking occurs during the snapshot generation? : sql server replication

1373

---

Distinguish between nested subquery and correlated subquery?

1112

---

What is Extended user-defined?

1029

---

What are the instances when triggers are appropriate?

1019

---

What is 3nf normalization form?

1166

---

What is precedence constraint?

1035

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

984

---