Wednesday, November 3, 2010
How to use optional parameter in SQL server SP
When you are going to write a generic SP for any business purpose you may realize the necessity of optional parameter. Yes Sql server gives us the opportunity to use optional parameter in SP arguments. You may write a SP with 3 arguments but based on your business rule you may pass one or two or three valuse as you want. This policy not only ease our life but also help us to write short SP. Here
Labels:
sql server
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment