Thursday, July 26, 2007

Diffrenece Between Function and Procedure in SQL Server

Following are the main differences between sql server stored procedure and sql server user defined function.

Stored procedure does not return values but it returns a integer value indicates that stored procedure executed successfully. While user defined function in sql server must return a single value. You can not return more than one value in user defined function.

You can call user defined function in stored procedure while you can not call extended stored procedure in user defined function in sql server.
Share:

0 comments:

Post a Comment

Your feedback is very important to me. Please provide your feedback via putting comments.

Search This Blog
Loading...
About Me
My Photo

Full Stack Developer,Blogger,Microsoft Mvp, Mentor, Life long learner, 10+ Years of Experience for JavaScript, web and Microsoft technologies. ASP.NET MVC,Web Forms,C#,AngularJs,Golang
Mvp profile
Subscribe to my blog

Enter your email address:

Follow us on facebook
Blog Archive
Total Pageviews