Answer / rakesh

mojor difference is
function must return a value but a
procedure may or may not return a value

Answer / a.suresh

1.Stored Procedure return 0 to nth value where as function
return only one value which is must.
2.we can't use the stored procedure in select select
statement where as function can be used in the select statement.
3.we can use all the dml(insert,update,delete) commands in
stored procedure where as select statement only used in
functions.
4.we can use try catch in stored procedure where as in
functions cant.
function must be used with its schema where as stored
procedure used with out schema name
ex.dbo.function name

Answer / g.ashok

Stored Procedure need not to return a value.
Function should return a value.

What is SQL server agent?

2 Answers   HCL, SAP Labs,

---

two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?

5 Answers   CSE,

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

5 Answers   Aptech, HCL, Perpetual, SAIC,

---

What is normalization?

9 Answers  

---

What is the most common trace flags used with sql server?

0 Answers  

---

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

---

What command do we use to rename a database?

0 Answers  

---

What are “phantom rows”?

0 Answers  

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

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

1 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---