Article is moved on the following link:
http://mysoftskill.blogspot.com/2009/11/ms-sql-server-stored-procedures-vs.html
Regards,
Vijay Modi
Posted by: Vijay Modi | April 4, 2007
MS Sql Server: Stored procedures vs. functions
Posted in MS Sql Server
This article is good to get some diff between UDF and SP.
By: Bhavesh on April 12, 2007
at 5:42 am
I will add …
I won’t agree on that
…
CREATE FUNCTION…Procedures are created as follows
CREATE PROCEDUREOne cannot call a stored procedure from a function.
By: Svetoslav on April 24, 2007
at 7:41 am
Thanks buddy. I am very thankful to you.
By: Vijay Modi on April 24, 2007
at 10:45 am
I would like to see a continuation of the topic
By: Maximus on December 20, 2007
at 9:04 am
it is not good
By: raghu on January 7, 2008
at 12:12 pm
Hi Raghu,
Let me know what is the problem in this article. So that I can update it. Thanks for nice comment.
Regards,
Vijay Modi
By: Vijay Modi on January 7, 2008
at 3:19 pm
Well I have a simple question are both stored procedure and function pre compiled sql server objects.
By: Harish on January 8, 2008
at 10:58 am
Hi Harish,
MS Sql Server: Both stored procedures and user-defined functions are precompiled.
Regards,
Vijay Modi
By: Vijay Modi on January 8, 2008
at 12:16 pm
Hmm…seems very similar to the article posted a few years earlier by Barrie Sosinsky.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1063700,00.html?
By: Rob on January 9, 2008
at 11:04 pm
Thank you for sending me the link.
By: Vijay Modi on January 10, 2008
at 5:11 am
seems you copied the article from http://www.experts-exchange.com/Databases/Q_20958686.html which was created on 2004
.
Nice copy paste
By: rax on March 5, 2008
at 6:24 am
Hi Rax,
Thank you. I added the reference on which I read this article. I was like that artilce and I also write the reference it just below the article. You can check on the following link.
http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1063700,00.html
Thankx for comment,
By: Vijay Modi on March 5, 2008
at 7:39 am
Rob’s point is worth repeating. Why plagiarise someone elses article (typos and all!). You are just causing confusion by making it appear that a 5 year old article was written in 2007.
Please just post the link in future or write something original.
By: Brett on August 12, 2008
at 10:11 am
Brett,
Sometimes someone’s article can be usefule to someone. And just for this I have added it here. Let me know if you have any concern with this.
Regards,
Vijay Modi
By: Vijay Modi on August 12, 2008
at 11:01 am
It seems that developers in India love to fill up the internet with useless articles. Do you need to do this because of intense job competition?
By: AlbanianTodd on August 15, 2008
at 6:50 pm
Hi AlbanianTodd,
Thanks for your comments. Indian are the first in Software Developement all over the World. Why do you know? They like to share knowledge. They believe to keep some important information and so others can also know it. I think you are from Canada. I like to keep some good articles on my blog like we are keeping some good toys & flower plant in our home even we have not made it. Some articles you can read which you have never read on another blogs. I am writing this because you told me about my country.
Thanks,
Vijay Modi
By: Vijay Modi on August 18, 2008
at 11:16 am
You are right, the Indian developers in North America are excellent.
By: AlbanianTodd on August 19, 2008
at 3:26 pm
Hi AlbanianTodd,
Actually if you can visit India, you will find the person are very honest to their work specially in our IT field(Software Developement). We indian developing different types of softwares. Even North America’s indian developers taught the developement in india and then they shifted there. Thats totally their personal nature. Hey What r u doing there? Nice to see your comments once more.
Best Regards,
Vijay Modi
By: Vijay Modi on August 20, 2008
at 6:30 am
Its a good artical.. for over all perspective.. but it can be more useful if some more points and some real things to be includes…
some points need to be clear with some examples…
By: Virender Kumar on October 3, 2008
at 7:51 am
thanks man it was usefull
By: umankumar on January 23, 2009
at 5:55 am
Dear Modi,
Correct yourself Sql Functions(UDFs) are not pre compiled. OK
By: Raghav on October 20, 2009
at 2:37 pm
Raghav,
I think, I am correct. Both Stored Procedures and functions are precompiled.
Thanks for you comments.
Regards,
Vijay Modi
By: Vijay Modi on October 21, 2009
at 6:45 am