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

What is difference between stored procedure and function?

Question Posted / rakesh

Answer Posted / rakesh

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

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why does sql studio use a single registered database repository? : sql server management studio

992

What is a partitioned view?

982

how can a database be repaired? : Sql server administration

967

Why do we use trigger?

961

What are various aggregate functions that are available?

976

List out the difference between union and union all in sql server?

986

How to encrypt data between dialogs?

1100

how to trace the traffic hitting a sql server? : Sql server database administration

1870

how many clustered indexes can be created on a table? : Sql server database administration

1144

What is normalization of database? What are its benefits?

1020

What are data files?

1034

Relational calculus is what type of language?

1030

Can a table be moved to different filegroup?

971

What is the difference between TRUNCATE and DROP?

1132

What are the different types of data sources in ssrs?

196