Total Page Preview: 000000002516
What is SQL Stored Procedures for SQL Server in English and Hindi
SQL store procedure in English
SQL Server Stored Procedures are a group of SQL statements that are saved in the server's database and can be executed on demand. Stored Procedures provide a lot of advantages over the direct SQL statements execution, like security, efficiency, and maintainability. They are useful when you need to perform a series of SQL operations on a regular basis, or when you need to encapsulate complex SQL logic that can be reused.
Here is a detailed example of how to create and use a Stored Procedure in SQL Server:
Let's assume we have a database called "Sales" with a table named "Orders". This table has columns such as OrderID, CustomerName, OrderDate, OrderAmount, etc. We want to create a stored procedure that will retrieve all orders for a specific customer name.
1-First, we need to create a stored procedure. Here's the SQL code to create a Stored Procedure:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkgAAACeCAYAAADJ5vW0AAAgAElEQVR4nO3df3QU5b0/8PdsdrNJFjaUm3AJbAixBCJQaDwaSvgC6WaxwX611hRqUxYqUFEjFr9yr8FeUl1uFVt6oFiKSLCFjdQLJ7YHT4Wjmxi0CddYRaNBAkTAbBJkI5KF/NhssvP9Y5zZ3ckm2fyABPt+nTMHdmafZ56ZyXHffJ5nowBABBEREREpNMM9ACIiIqKRhgGJiIiISIUBiYiIiEiFAYmIiIhIhQGJiIiISIUBiYiIiEiFAYmIiIhIhQGJiIiISIUBiYiIiEiFAYmIiIhIhQGJiIiISIUBiYiIiEiFAYmIiIhIhQGJiIiISIUBiYiIiEiFAYmIiIhIhQGJiIiISIUBiW4YDocD1dXVwz0MIiL6FzD4gDQvB9j5sX9buwuITwSePRq8f16Ov83aXcHHnj0qtVH3uSS/5zaB/RpigV8WB+//ZbG0vzc3ZwDb3g09ziX5vfcXOB71+NX9ym3V90o+X6j7JV97fCJgOyz1GXh/5D7V92XtrvDvcy+qq6shiqKyFRYW9tnGarXC5XLBZrN1O1ZYWNjv/q439TU7nU6Yzeaw2qqvb7BBzmw2w+l0Dut9ksfgdrthtVoBADabDS6XS3lNRPR1pR1U6yX50of19vuBTyr8++MTAU8rsH2DtH9eDnDXI8CpSsBVJ72ntAg4uDl0v9PnAX/fCaR+RwoBLc3Ac2ukYzdnAD/ZCDx3v78vObgU/QooL+7fNbib/H3Ny5Gu6VKjdOxEuXReQyyw7kXgjgelMS/JB4xxwPp50tiW5AP3bwO2rQS+bQGWPdXzWJw10vtamnu+X/GJwPoi6VjZS31fg3wv5Xbzcvzn7u0+h2A2m7Fv3z40NzdDEISw2/XGZrNh6dKl2LRpEwoKCmCz2bBu3To0NDSgoKBgSM4xVEpKSmCxWJT7kJubi9LS0l7bOBwOzJ8/X7m+r5uOjg6sWLECdrt9uIdCRHTdDLyCZIgFpt4mffgGhqNQLjUCggDEhVG9iE8EogzAO4ek15NmDHiI/XaqUgoqYxOC97c0S0FqfLI0vm8tBF75nT/klL0E6GOksd5yuxRK+hvUArnqgEPbpfsbPTr8dq1uaZwTUgZ86tzcXBiNRmzeHDpU2Ww2eDyebpWg6upq7Nu3D3Fxcdi4cSNEUVQqDzk5OaisrFTCQ0FBAerq6pCRkQGz2Yza2locOnRI6TewcuNwOJRzZWVlBY0l8Ji6ylFbW4vy8nLluMPhAOCvioRqp+bxeNDQ0ACbzQa32x1UGXM4HHA6nXjssceQmpoKu93eLRypK2rq1+p7KVedHA4HSkpKMHHiRKxatQqiKMLj8SjteqrGVVdXo7y8HB6PB9XV1UpFTD7e07Pr6RmkpaUBACoqKpCQkNCtmma1WuF2u7vdS6vVCqfTiffeew+iKOLQoUNwu91B9zqwWtefSh0R0fUy8IAUY5RCgVxt6c3MBUCzC/gsYNrBvCz01M/UdODCWSkknK+W2oZr2VP9m2JTm5ou/XmqMnh/fCJgSgXef90f8prq/Mdb3VKwGn+TVFlqON3zOUzTgC3loaceA11qlO5v9Kjwxz9pBhAbD3z8ln9fT/e5B5MnT0ZdXR3sdnvQB7HD4YDVasXKlSuxevVqCIKA5cuXIzs7G1arFTNmzMDy5cvR1NSETZs2QRAEGI1G1NfXIzY2FufOnQs6T2NjIxISpCCq1+txyy23YPHixUoIys3NhcPhQGpqKrKysiAIAkpKSpT2hYWFSEhIgCAIEAQBBw4cQH6+f0rWZDKhra0NgiBg06ZNmD17NqxWK3Jzc5XqmDzGwMpIVlYWRFFESUkJzp49i4KCgqBAB0iBIjU1FUeOHMHFixeh1+vR0NAQ/nP6Sk5ODux2uzKWGTOkfwxYLBZkZWWhvr4ee/bsgSAI0Ov1KCgoQGFhIZYuXYrly5cr17Z06VIlPH3rW9+C3W7HlClT0NjYiBMnTmDy5Mm9PruenoH858WLF5VnEshut8NoNCrjr6ysxIoVKwAARqMRUVFRKCkpwfe+9z0cOHAAHo8HKSkpcDgcaGxsVNqdPHkSTzzxRL/vHxHRtTTwgBT3VaWnJ/oY4JEXpA/mqbd1n1YqLQIenCltjy+UApEhFsjM9QeMj98CkmaEH3SKfuXv89c5wefriTFOWuOz82NpGnDLMv/U3fR50n7bYami01dVSB8t9dcbZ400NSePczCVJpkcgtb8HvhTfnBFL9R9DpP8YXrixAkAwMKFCzFx4kTs27cPoihi3759iI+PR0rKwCtWsiNHjqC0tBSlpaUwmUzYv3+/EkJCTXHNnTsX06dPVwLcqlWrEBsbq1Qi3G439u7dC0CqWMXHx8Nut6OhoQFTpkzpsXJUUlICQRCQlZWF1NRUpfJUXFyM5ORkmM1mZGZmwuPxYP/+/UhJSYFerx/QNTc2NmLVqlX9Wq80efJkVFZWKqGurKwMbrcbEyZMAABUVlaioaEh6PqB8J6d+hls2bJFOVZcXIzvfve7MBqNyj51NS4rK0sJvR6PB8XF0s/2mTNncPToUWX8cugN1Y6IaKQYeEBqqgNEsft0lMzTKq1NKlgshYaVv+m7z0kzgPhJ/krQIy9IlZtrOc3mbpLGGCpAnCiX9pcWSeuMbs7wV44Cpwvlatrn5wY9xaUYmyDdw7arPY9bDoByCKp9H/jZM2EvxA7l3LlzQUFD7cSJE8q//AMrGz0pLS1Fc3MzJk+eHLQ/ISEBjY1hVB97IVdX5M1kMvW5XqigoAB6vR55eXnYsWNH0NSVetwnT55UPrjLysqg1+uRm5uLjIwMnD17FqWlpTh9WgrzckDpD4vFAkEQcOzYsesy1dTfZxeooKAAly9fxk033aTsk6s+oSp8vfF4PEqVUV09IyIaKQYekFx1wD8PS1WX3j6Q5feZUvv+4J65QPqQlysecoWlP9Ns10LZS1JYmblAuh7XZ4Blhf/4vf8l7Tv+BlC2X5o2C/zWWX/dnCEFsrL9wBf1/nMD/irbhbPd2zn2SkFNniocgKNHj8JoNIac8pCrLz19s6q+vh4ej6dbWDh27BjS09OVik1hYSESExODKhxqcrCaO3eu0iZwDVJjYyOWLl064G9TydNDZ86cCRlu5Gk0OcSVlpbiyJEjyM7ORmpqqjJ2u92OysrKHsei1+uV/vPz84MqMLLVq1dj+fLlAICJEycGXb86WJ47dy7oXsprxuQKTU/6enbhOH78ODIzM5XXCQkJaG5uRmlpKaxWK9LT+/65O3fuHNrb27Fy5UquOyKiEW1wX/M/uFkKP/IUlfpr5rLXdkoVj8yf+vep18ZMmi5Nxb3/enDbhtPArYvDq4oMdg1ST+RF0/I4XvxPqSomn8sYJ+0DpEB3cLN/elE9lp7WIAVOSa75PbDrF1JfLc3AC+ukc+/8WGrrbgr9zbRPKqQ2mbn+8/VzDZLdbkdeXh7S09OVKZDp06fj3LlzKCgogN1uVxYOq6secoiQj8vTWKtXr0ZlZaUyvWO1WrFt27Y+vxW1efNmJCYmQhRFZGdn4+WXX1aOWSwW1NXVKX0GLsTuTeDCblEUAUgBRRa4BunkyZOwWCzKMTk8Njc3B43dYrEEXZ+84FoOT/L9uHz5MpxOp/RYVNNT+/btw5EjR4L6LS4uxvz584MWaQ/0Xvb17MKxf/9+uN1uZUqxuLgYU6ZMURZ8f/TRR2H1s3btWgDSdOZI/rUPRPSvTQAgDvcgiG4EVqsVO3bswIEDB4JCFRERff3wN2kThWnFihVwu93Yv3//cA+FiIiuMQYkoj7Iv+4gPT0dGzZs6HMhOBER3fg4xUZERESkwgoSERERkQoDEhEREZEKAxIRERGRCgMSERERkQoDEhEREZEKAxIRERGRCgMSERERkQoDEhEREZEKAxIRERGRyg0TkMYJMfjAsAJtox+Fc9QDmKWJH+4h0Q2suroaDodj0P3YbDbU1tbCbDYPwaiIiGgkEUf6Nk6IET8wrBAXaZNEAOIsTbz4ZsyPxXFCjPLaOeoBsW30o2Lb6EfFv0bfLRoE3aDOmReZJm6PyhrW616kTRLbRj8q5kWmKfu2R2UFvb5e4/jAsEK53wBEg6AT/xp9tzIW+bX6fXmRacpzCfVsQj27yZpY8c2YH4uzNPFBYwhsK/9MqPvbHpUVdL5Qz9DhcIhOp1M0m81BY+9pnPK55GPyz2Fgf9XV1cP6s8KNGzdu3IZ2uyEqSEt007DbW4U3Os8DAKp8Lnzka8LsiHgs0ibhHcMy3Nd+GNFXtiL6ylb8sO1vaBG9wzzqoXHK9yV+pJ2KcULMsI3hwy4XAGB2hL9q901hDMYIehz01iivT/i+wFtdzqD3AcBubxWir2xF3NU/AAB+ppsJAD0+u9Ywnt3siHj8xXsSbrED3xTGBB1b7ylD9JWtSLq6CwsiTFikTVKO2Ww2zJ49O+T/dPautle6/QwZBB12Rd2O/wjo84nI7wRVMJ9++mnExsaisLCwz3ETEdGNQTvcA+jLOCEGlogk/D/Pm/hr9N3I1iajxncJv+v4J6ZqxmKaZizWe8qU8BQoLzIN0zRj8Uh7ScjX26Oy8HPdLADAF2Ib7mgtBgC8FpODfxOiAUA5vt5Thh0dx2EQdCiK+j6ytckAgCOdZ7Gs/e/4pjAGj0XeBgDI0k7CBs/beEY/H+92XcCy9r/DAB1ej1mCaZqxQf3J43i36wIei7wV0zRjUeO7hNtbDwIAPvVdxv92NWJ2RHy3a8yLTMMWfabyWu5ze1QW6n1XsTYyDa90nlau4662V/BG53nM0sQHXaO8vycXxVa81eXEndopyvvma034yNeEi2Kr8rqs6zMACHpfoBbRizrxinIP7tRO6fHZ9SUzYhL+x3sSV7UdmK81oarD1f188OKsrxlTNWPxBqRz5OTk4MMPP4Tdbg/rPBkREwAAFV0NAKRg9p2ICUHnLC0txZEjR5CdnQ2z2dwteBER0Y1nxFeQxgsGnPB9gSmaMagTr2BOSxE+7HLhitiBSEQgURiNU75L/e53liYesdAj7uofEH1lK0xXn0eVz4Uqnwumq89jvadMqXxEX9kaFI4cXeeV/XXiFTyjXwBACkaVvka80nkaj0XeivvaD2OMoEe8EI3f6jOxvO01pZKSrkkIqkI8Fnkrbm89iOgrW/FWlxNLdNOUY0e76rBMOwMGQRd0DTs6jivjSLq6C5aIJKXS9BNdKu5rP4x7tCmo8V3Cbm8VpmrGYpwQg6f083BLyz6l3UO6tD4rVK92nsGCCBPGCTEwCDpYIpLwaucZAIBB0GGaZiw+7HLhwy4XEoXRIfsbJ8RgQYQJr3aegUHQ9frsviFE4R3DMrSNfhRtox/Foeh7gvoZLUSiVryMtzudSNckdLs3gFTVukkzBm93OgEAZrMZUVFRqKioCHnOQ9H3KOeTq05TNWNRJ15Bi+hFXmQaHtKl4UlPhRLyZEePHoVer0dmZmaoromI6AYz4itI/66JQYN4FXdqp+DVzjP4d00MmuFBCzqgFyKQrIkdUL8XxBbMjohHjWEV7mgtRpWvewVCzQDpQ1ieVgKk4PCQLg1RghanfV/ioLcG/6Wfi93eKnzuk6orSUIssrSTsDQg9ABAUWc14JP+vttbpVRj5AqX/CH9kc+FZniUaoZskTYpKDh8IbZhvGBQ+vvc1xo0JkCqgGRrk3F+1Jpu7eTzhxI4zfa5rxVjBL2yLyNiAhKF0WiBV6kSBVa8fq6bpVTi5GrVOCGm12f3pdiOOS1FynNZpE3CQ7o0AFDCY4voRS0uA5DCUJUovXeLPhNb9JlKVVDuY+LEidDr9Th9+nTQuVpEL37Y9reg+/qnqMVKRRGQqnwA8MO2vyEvMq3beOvr6+F2u3u8HiIiurGM+IA0VTMW9b6rSNck4HNfK+ZrTaj5qurgEbu6TaGE66LYim+37A2aMutrqmkwSjo/w0OeNwa8Nqqwowo/1qUqr8cJMfitPjMocPxP9J1h9bXbW6WEsHBdFFux21uFO7VTUOO7FDS9dqd2CrK1yWga9XBQG/leyufLi0xTgketeHlAzy7mq+pVtjZZCV0AUOlrVKa8Aqca90XfgdtbD/Ya/tQ+7HLhtO9LAMAp3yVs0WcGTYnK06BERPT1NeKn2GRGIRI3acbAEiFVVTIjJqGk8zz+6D2ODZFzevzaf6IwGgZBh1maeGyInNPtuFw9WO8pw9SAaZNTvktKW+W9kMKNXMEwCDo8pEuDo+s82sXOHsfuElsxOyJeWZw8ELXiZZiE0VgYkQhAmnoUIChVqiW6aUjRfKPPfj73teIebUrQwuVwvd3pxMKIRNyvm61Mr40TYvAtTRzmtBQFTfeFmmY76K1Bk9iG+VoTWkRvn88ulGQhFmMEPZKu7lLON6elKOQ0W2FHFeKEaGXReH19PTweD1JSUno9xxLdNFwWPagVL+PDLhf+t6tBmaabpYnHwohE5bWsp+oUERHdmEZ8BemU7xKmasbC0XUef4n+v3jSU4ENkXPwSudpaerEB9zXfhjvGJYpbeSF0we9Nfi5bhaaRj2MGt8lbPC8jdsixgPoPj0lt5FVdDXgIV2aUhWRKwhr2l/H6zFLlMXRu71V2NFxvNcP+SaxDcvbXsNrMTlKO3khdriVjRbRi6LOamWarsrnwtGuOuW6D3hrUNL5WZ/9VPlcuK/9cMhr76u6VStexqe+y0jWxAZNuclhQhmrKkjKLoqt+A9PGX6rz8RBbw3e6Dwf8tk96nmzxzHMi5gYVL0C/NOl6inIKp8Lz3S8g4d0aajoakBpaSna29uRkZER9L6eFt63iF60wItftJcqi9rV03ayhQsXApBCGBERfT0M++8a6G2bpYkX90bdMejfa8SNGwDRZrOJLpdLtFqtQ9an2WwWnU6nWFhYOOzXx40bN27chmwb9gH0uoX6hYSPR85hYOI24E39iyKHoj/+okhu3Lhx+3ptI34NUovoxZr21/Fz3Sy0jX4UTaMexlV0fG1+ESRdfxaLBc3NzcjNzR10XzabDcnJyVi7du0QjIyIiEYKAVJSIiIiIqKvjPgKEhEREdH1xoBEREREpMKARERERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoBEREREpMKARERERKQyuIA0LwfY+TGwJD/0fnlbu2tQpyEiIiK6nrSDaj19HvD3nUDqdwBDLNDSDNycAXxvNVCwGHDVDdEwiYiIiK6fgVeQ4hOBKAPwziHp9aQZ0p9jEwB9zBAMjYiIiGh4DDwgTU0HLpyVqkTnq4GZC6T95cWA8yRgOwz8sliqLBERERHdQAYWkAyxQGYu0HBaev3xW0DSDH8Yem4N8OBM4NS7wJZyrkEiIiKiG4oAQOx3q5szgDW/B/TR/n2eNmDXL4BPKoLfG58IrH0B+Mum7seIiIiIRqCBLdKeuQCofV+qFMmW5Ev71SEo7qu1SkREREQ3iP4HJEMsMPU2oGx/8P6G08BdjwDRo4C5d/v391RZIiIiIhqhBjbFRkRERPQ1xt+kTURERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoBEREREpMKARERERKSiHVCr+ERgfRFg/Df/vtIi4OBmwBALrHsRME3zH3PWANtWAi3N3Y972oBdv5D+vub3gD46uN0L64D7twHGOGDLMsBVB9ycAfxkI/Dc/dJrIiIioiE0sIAEAJ5WYPsG4JMKf2ApewlodUvHi34FlBcHt5GD1T8PA7/O6d7nutu6hx9DrHSsow3I/KkUwoiIiIiuoaGbYnM3+cNRTzJ/Kr3vtZ397/+dV4Hxyf7ARERERHSNDLyCpI8BHnlB+rs8TSZPoQHAsqekDfBPsY1PBk69K71vST5gXiYdD1VtUvvyApA8C/i2BbjUOOBhExEREfVl6KbY7tsM/Ckf+KxaOt5X6Dm4WaokrXsx/HM69gLff1Ba70RERER0jQzNFNtn1UCzCxib0Pv7LpyVqkgD9UmFdJ4JUwbeBxEREVEfhiYgTZoBxMb3PfX18VvAN28B5oVYoB2uE+XAgh8PvD0RERFRH4Z2DdInFb2vQfqkQnrfmt/7j3napGB1c0bw1/xth/1f8w/0gQPIzJW+9k9ERER0DQgAxOEeBBEREdFIwt+kTURERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoB0nTkcDhQWFg73MIaNw+FAdXX1cA+DaFC2R2WhbfSjaBv9KPIi04Z7OER0Ddw4AWntLmDnx/5tXo60/+YMYNu7wceW5EvH4hMB22HpPWq9tQOk/gOPrd0Vus3Oj4FfFgOG2F6H73A44HQ6IYoixo0bB7fbDZvN1v/rfvaodF3xidLfQ92TUOOXjy3J9/cR+L7Atj0oLCyEKIrKdkMFvXk53Z+TIRZYbwd+9J/dj63d5f95GMgzMMRKffbz5wQAzGaz8rMiiiI8Hk94Pyu9KCwshNPphNlsHlQ/g2G1WuF2u4PGMRLG1V/bo7IAANFXtiLu6h9giUjCIm0SAGCWJh7OUQ8o4emv0XfDIOgGdb68yDTlnMNlkTapWxjcHpXFcEhfa9rhHkBY5A+qB2eGPu5uAp67H3DV9a/fntotyZc+6LbfD3xSEXxs3W3Sn2t3ARfOAgc3h3Uqi8UCm82Gxx9/HC6XC3fffTdKS0vDG2dpUffzxCcCnlZg+wZpjPNygLseAU5VAnGJwA9+4R//zRnAfZuBS41SW+dJYGq6dN03fRtw1vQ5BJvNhqVLl2LTpk0oKCiAzWbDunXr0NDQgIKCgvCu40bW32fQ6pbeU/QroLw47NNYrVbs2LEDdXV1MJlMQ3gBI4PH44HRaERubm74P/8jyCxNPGKhx0OeNwAALaIXf/Qex53aKQCAQ9H34K62V/BG5/nhHOY1ccr3JX6knYqD3hpcFFuHezhE19yNUUEan3z9zmWIBabeJn0YqsPRIDgcDqxcuRJvvfUW3n//fRw+fHhoKzCXGgFBkMKRZQXw7mv+8X9SAdR9AsxcIN3Ls1VSMJKrSO6mPrvPyclBZWWlEoYKCgpQV1eHjIwM2Gw21NbWory8XKl6OByOoGuX92dlBf9LOPCY2+2G1WoFIFUWqqurUV1d3a1ipa6wBLbr9f54QvxH3dMKXP2yz+sPS+AzGKCFCxfC7XZj7dq13Y7ZbDa4XC7lWtWvA++VXHWSqzarVq3CxIkTUVJSAlEUg6Y5A9vJ91J+prW1tfB4PDh06BA8Hk9QtSewnboq1NOzA4CysjKkpXWvPAT+LAT+DDkcDrz33ntK9Un+OZOPy9cY6mdvqK2OnIWizmr8TDdTqRKNF0YBAO7RTsV6T1nIcKSuAqlfB07ZOUc9gFmaeKUatUWfiZ/rZnWb0jMIOvw1+u5u1apZmnjsjboDe6PugHPUA7DqZsA56oGgalbg+dT7rboZ+MCwAm2jH8UHhhUYJ8QAAD71XcaRznOYHREf8vrk/gLHuD0qC49HzoFz1APYHpWlnLenipu8n2gkuDEC0sv/DZhSu0+DyYxx0lRaqKmy3oRqF2ME9DH+assQsVgsMJlMEAQBFy9ehF6vx+rVq8NrbF7W9zTNzAVAswtoqpOuq+F08PELZ/1B88sL0p9z7gI+/UA6NiGl59ObzYiNjcW5c+eC9jc2NiIhIQEAYDKZ0NbWBkEQsGnTJsyePRtWqxUOhwOpqanIysqCIAgoKSlR2hcWFiIhIQGCIEAQBBw4cAD5+f5nN336dBw7dgyCIGDPnj3Izs6G2WxGbm4umpublXZGoxF2u73v+2iMk56vPH0WY5T2AYBpGrCl3H+fp89T3YRl3afY1ORn8FnAGqtlT/Vrim3y5Mlobm7ud3XFZrMhKipKuc96vR4FBQWw2+0wGo3Ys2cP6uvrleMzZswAACUoyfeysrISzzzzDCZPngyTyYSzZ8/izJkzyMzMhN1uh16vx8SJE+FwONDY2Ki0O3nyJJ544gllPKGe3fTp0wEAn376KcaMGdNt2tBisSj9LV++HKmpqUr4mzlzJg4cOACj0YgxY8agpKQECQkJMJvNePLJJ7Ft2zYIgoCsrCwkJyf3OSWpni4OZypTDhEXfC2wRCRhesuLOOCtwQXxKrTQwKQZjVO+S/16boC/KhV39Q+IvrIVpqvPo8rnQpXPBdPV57HeU4bd3ipEX9mK6CtbsaPjOAyCDkVR34ej67yyv068gmf0CwAAWdpJqPQ14pXO03gs8lbc134YYwQ9DNAhLzINNb5LSjtH13n8TOevzj8WeStubz2I6Ctb8VaXE0t005RjR7vqsEw7o9u04Y6O40p/SVd3wRKRpASrn+hScV/7YdyjTUGN7xJ2e6swVTMW44QYPKWfh1ta9intHtKlKe2IhtuNMcXmqgMeXyh9uKx7UfqwCZy6GMoptpszgCjD0I1dxWKx9L9RqOkdOcg98oL02lkDbFsZfp//PAx8/0Fg58O9hqNwud1u7N27F4BUXSooKIDZbEZqaiqOHDkS8gN/7ty5mD59OkRRVPbV19crlYj6+nrs378fAILCZGZmJqZMmQK32428vLzwwlFTnVQtijECzRelsBhj9B+X719Ls/R67a7g9j1NsYV6Bi3N/iDUzyk2OXD21+nTpxEfH4/Dhw/j2WefDWva02w2IyoqCi+99JKyr6KiArNnz4bRaFSeaX5+PiorK9HQ0ABACj+pqamYOHFi0LM7ceKE8vdQz04OO263G2+++SZycnJw7NgxpU1hYSFWrVqlvO7o6EBKivSzeebMGRw9ehQ/+MEPUFxcjIwMaV1hZmYmTCYTNm7ciI0bNyptJ0yY0Ou1r169OqrxBQwAAAeeSURBVPx/oHzFACkUfFPzDdSJV9AiemEUInHB1wIdNEgSjH30ENoFsQWzI+JRY1iFO1qLUeVzhT2Wg17/9PirnWfwkC4NUYIWp31f4qC3Bv+ln4vd3ip87pOqpzGCFpaIJGRrk7FFn6m03e2tCvq7PIX2SLv0Dxq5svORz4VmeJAREXx/F2mTcCj6HuX1F2IbxgsGpb/Pfa1BYwKA2RHxyNYm4/yoNd3acQqPRoIbo4Ika2kGfp0jfehk5oa14LXfmuoAUQTGDuyD6rrytErrjAoWS5WQlb+R7pG7qXvoGZ8MfNHgr459UgFssfoDQS9KS0vR3NyMyZMnB+1PSEhAY+PgKm179uxRqgaCIMBkMvVZPSkoKIBer0deXh527NjRv0XMplTg0gWgvUX6u7sJ6Ggb+AWEegaD0NjYiNjY2H4vWpYrRYsXL8bKlSuv+SJ6j8eDTZs2BT07uSoVDjk8jRs3DgCwaNEiLF26VPl5WL58Odxud1h9OZ1OpTImb32Fn4FUkMYLBlwROzBRMwo1vksYLxjgFjtwFV544cN50Y2pmrFh3gG/i2Irvt2yF9Na9uAp/bxrPtXkFjswp6VIqfhEX9mqBKFwFHZUITNikvJ6nBCD3+ozcVfbK0ol6LQvvGnrwMpYYPWMaCS4sQKSbAgqHj1y1UnVlbseCT2NMhLJYzalSmN+/3Xg1sXB31QzpQL/ODjgUxw7dgzp6elBa4QSExOVqlEocrCaO3eu0iZwDVJjYyOWLl3a9/qhHsih4MyZM31WDNDqlsLMLbcDtceBE+XA3LulwDgU1M9ggPbu3Quj0Rg0XRVIr9cjJSUFZrMZK1euhF6vDzpeWloKk8mEkpKSoEDb0NCgTI8Fvre9vR05Of5vMObk5ODixYuoqqpCT06cOIH29nasXLlywN8+Ky0tRWNjo1IJksclV6lWrFgBo7HvioxcOevpfvVk9erVQYEqcFoyHNM0YzFfa4JRiMRszThU+5qwveM9bIicg1ma7mt0ACBRGK2sEdoQOafb8RbRix+2/Q3rPWVBQeuU75LSVnkvvACgTH8ZBB0e0qXB0XUe7WJnj+NuFTvRDA+e0s8b8LfrasXLMAmjsTBC+jkfLxggQFCqVEt005Ci+Uaf/Xzua8U92hSuO6IRa+QHpFBfl556W/B0SG9rkOQpkFDrQHpqd3Cz9GEXeEw95TLSvLZTqoZk/lSa0gkc/5J84M8bgC/qe27fx0L41atXo7KyEvv27YMoirBardi2bVuf01ubN29GYmIiRFFEdnY2Xn75ZeWYxWJBXV2d0me4C2zVi3nl8fVJHyM988+qpW+axU+SQpMnjApSOGuQAp+BrJ9rkOx2O/Ly8pCent6tsiEvjN+4cSNKSkrw/vvvK1UWdUUkNTUVTz/9tNJvQUEBLl68qNxree3R2rVrERsbq7SLjY0NuUBcTX6PvOh7IBWrvXv3IjIyEgDw5z//Wbk2URSRnJwMp9PZZx92ux3btm3D/Pnz+7dofwAuiC0YLUTiva7PcY82Bekaqcr8pD4DB701eKPzPO5rP4x3DMu6LYA+6K1BsiYWTaMexr7oO7DB87bSr/wVenmzRCThz96PleMVXVJobBr1sLIAukX0Yk3768ri7aZRD6NOvIIdHcf7vI4NnreC+utvxapF9KKosxpTvwpBVT4XjnbVKdedrklASednffZT5XPhvvbDOBR9z5D+WgSioSIAEPt8FxHRvziDoMMf9Yvwu453OQ1E9C9g5FeQiIhGgBbRi0pfY9D0lFU3o8cpNSK6sd0Y32IjIhoBdnQcx7SosWga9TAA4EjnWbzSeWqYR0VE1wKn2IiIiIhUOMVGREREpMKARERERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoBEREREpMKARERERKTCgERERESkwoBEREREpDLw/xfb2l3A9Hn+1+4vgC3LgMyfAuZlQNGvgPJiwBALrHsRKNsPTEiRjqnbuOoGcQlEREREQ2tw/7Pa0iLg4Obu+69cAubeDXzg6H7sRDnw3Brp70vygfVFDElEREQ0olybKba6T4BmFzBpRu/ve20n4G4CpqZfk2EQERERDcTgApJ5GbDzY2l79igQn+g/dqIcsKzovX1LsxSQJqQMahhEREREQ+naTLEB0vTa3LuBad8Z1CmIiIiIrrdr9y22lmbg2N+Amf+n5/cYYgFjHNBw+poNg4iIiKi/ru3X/E9VAlNuBWLjQx9f+Rvpz1CLuYmIiIiGyeCm2MzL/F/bl7+yH8hVB3x0NPir/dPnSWuWAGmd0q9zBjUEIiIioqEmABCHexBEREREIwl/kzYRERGRCgMSERERkQoDEhEREZEKAxIRERGRCgMSERERkQoDEhEREZEKAxIRERGRCgMSERERkQoDEhEREZEKAxIRERGRCgMSERERkQoDEhEREZEKAxIRERGRCgMSERERkQoDEhEREZEKAxIRERGRCgMSERERkQoDEhEREZGK5vnnnx/uMRARERGNKJoVK36Gf/yjHPfeey/i4uKGezxEREREwyIuLg733nsv/vGPcghtbe3icA+IiIiIaCThGiQiIiIilf8PRy8gyjNr8MUAAAAASUVORK5CYII=)
In this example, we have created a stored procedure named "GetOrdersByCustomerName". This stored procedure accepts a single parameter called "@CustomerName" of type VARCHAR(50). The SQL code inside the stored procedure selects all the rows from the Orders table where the CustomerName is equal to the @CustomerName parameter.
2-Once the Stored Procedure is created, we can execute it by calling it with the parameter value. Here's the SQL code to execute the stored procedure:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkoAAAAyCAYAAACjzfQcAAALIElEQVR4nO3ccUwb1x0H8O9NXR2ayK4q2GogE2lcjZm2aIsWLeSPgO1ItKv6x7KSCu2MBKhVldKlate4yXA1M6VJ10lZW5SkMpHg2oh1y/6I2g6p51OiCSJ5ijKq2KMLKJHAuAGWgZUWLv94f5zu2QYOQ0Iwbb8fCYH97p7fvYvkb37v2dLs7FwaAIqKNoCIiIiIMr5T6AEQERERrVcMSkREREQWGJSIiIiILDAoEREREVlgUCIiIiKywKBEREREZIFBiYiIiMgCgxIRERGRBQYlIiIiIgsMSkREREQWGJSIiIiILDAoEREREVlgUCIiIiKywKBEREREZIFBiYiIiMgCgxIRERGRBQYlIiIiIgsMSkREREQWGJSIiIiILDAorSFVVRGLxQo9DCqkx7YCPYcAz7bV6evtXwPff+DO+1oLB2XgzeeBTUWFHgkR0bKtXlDauQc4fjn3Z+ce4OkAcPQ8ULLZOG6jAzh0Bmg7aTxuO5l7Tvaxi7Xv3JN3KB6PB2NjY0in00in09B1HaFQKO95sixjcnJy0WNjsZjoL5VKQZblZU3LWsoeYzqdxtjYGDwez22dGw6H72gsS83lWjH/HWTfr1AohMnJycLdv+v/A+ZuLXz+oAz8+XeZn6bH135sgPG62eN47zerF8QSU6vTDxHRGrpnVXsb+xw41gx8OZP7/INbgGd+C7zzHPDE88Zzp17NtGvvA385knvORgew/5Tx9ys7F/ZpQZZldHZ2IhqNory8/DYvJJeqqnA4HPB6vdA0Daqq4o033kAikYCmaavyGqslEonA5/PB4/Ggp6cHjY2NS47RPA6AuL5vmlu3bqGpqQmKohR6KNYOZ42tUCHJNDicGU/T40BHC9DeBVy/UdhxEREVwNosvfX+HiivBF5RgJ8+Afztj/mDzw+qANt9wHv7lx2SAKCpqQmpVAqHDx9etD0UCkHX9QWVk1gshp6eHhQXF6O9vV1Ujk6cOIHq6mqcOnVKhIju7m7YbDbU1tYiFAphZGQE/f39ok9VVcXrqaoqnvd6vTljya7iZFd/wuEwYrFYTrs5zvnVsqWqW7quY3x8HKqq5vRv9qGqKmpra2Gz2fDaa68tCEnzq0LzH4fD4ZwqlHndVnNpjnP+edn3oL+/H7qu51y/2Z49l/OrREvdg4GBATidzgXVtfn/Fsw5MvsbGRmBrus4e/YsdF3PmUOre5fX9RvAs38AtIvLOx7ILNdZVZsad2fazCW9x7YCoRbjZ37bSpw5B0zfBKq2GI+zK1/zq03Z1ajFKlHdfwdePQ7cnF35OIiICmR1g1L5D4G3+hcuk02OAmffBrb+GPjnJ8C/B3LP8/xq4dLbA05A/wr4KrWiITidTgwNDYnKT/absSzLaG5uRmtrKyRJgt/vR319PWRZRlVVFfx+P6amptDR0QFJkmC32zExMQEAuHLliniNRCIBXddRWlpqXHZ5OWZnZyFJEjo6OlBdXQ1ZlqGqKiorK+H1eiFJEiKRiOhDVVUkk0lIkgRJkjA0NISDBw+KdrfbjQsXLkCSJHR1daG+vh4ejweNjY2YmZkR59nt9pxKidfrRTqdRiQSwdWrVxEMBnOCHQARjrq7u1FaWgpd15FIJFY0zx6PB3V1dWKuJEmCz+cDAMu5VBQF4XAYDQ0N8Pv9Yr4aGhpE+Hr00UehKApcLheSySTi8TgqKioQDofhdDrFa3344YcIBAJiPIvdg927dwOAuIeNjY051xAMBmGz2USfMzMz4pjy8nJcvXoVw8PDqK2thaIosNlsKCsry3vvVtVjW4EX9gBv9QJ7Xwde/BOw85FM6Ll/E1B0r9F28ixQvz2zB6jiQWOZb7G25bo5awSlzd8zQhJg9Lf3daD/MvDyXqNPzzagrDjT1qsBLT9fvXkgIiqQ1Q1KY58by2TPP2L89J/JtJU+bPx+cMvC87T3M+cc2GUEK/P4O+Dz+eD1ekUI2LVrF8rKytDT04N0Oo2enh6UlJTg4Yfv7LVSqRS6u7sBGG++JSUlSCQSqKysRF9f34JKjcfjEQEqu9rkdDrFMYlEAqdPnwYAtLa2ory8HJqmYXx8HC6Xy7KSFIlEIEkSvF4vKisroaoqFEXB4OAgampqAAA1NTUYHByEoiioqKi4rWvWNA1zc3Nob2/Pqd7kU1FRgWg0KsLduXPnkEqlROiMRqMYHx/PmVMA2LFjB9xut5ivlpYWOBwOUclZ7B58+umn4vwzZ86grq4OdrtdPCfLMlKplOjT7XaL+cjuzxwTYATYfPduVRXfD1xLAp+NGI+v3wCufWEEF8AIMV0fG39PTQMb7gU2FuVvW6nv3mOc/1HWf3Iu/SfT58/cQLUrU1F67ikjxHHjNhF9za3N0tuPaowlt4+PA1t/sqwN2Ri/AtiLgfvs+Y/Nkkwml3zTisfjohIgSRJsNhuCwaDl8WYlKTtMlZWVwWaziTfP26Hrek41RpIkVFVV5T3PrILs27cPnZ2dlhvVNU3D0NCQmIuBgQFUV1fjpZdewpYtWzAwYLzhXbt2DXa7HWVlZSu+hqqqKkiSBABIp9N3/RN9XV1dOfNlhsflCAaDmJ6exkMPPSSeCwQCGB0dFf3F4/Fl9XW79+5raVOREXgSk/mPPXk2U1Ha+zqX2YjoG+HuB6WNDuAXLxtLbh91GlWmp17M/WTbYv6lAqkpYxP4CgwMDMDlci36qS2zGmP1ia75S2oAoCgKJiYmsGdPJtwFAgFMTEwsGbA0TcPMzAx27NgBwNiXY+5RMqsxzc3Ny9/bMo+iKLDb7RgeHs4Zr8msWiWTSQBGUJiYmEBrayvm5ubE2E+fPo1UKpWzjJXNZrOJ/gOBQE5FxuTz+dDR0YENGzaI61lsLgEjmG3fvl1UwxobG2G323H+/PklrzeZTKKhoeGOPq126dIlsfzodrvhcDjE/IRCIbhcrrx9xOPxO753C2wqAp6uy/xdVQGMGsuFmJoGKpzGEhxg/K5wGtWctfDiL43f/xg0lvGerMm0PVkDfHHDqHIlpoBnPF+fryogIlqmu79HqflNo+2T45nfqSng2WNGiAIW36P05YzxCTp78Yq+HiAYDOLo0aOQZVns1SkpKcH4+DiCwSAURUFLS8uiG3E1TUNfX59oN5e32tra4HA4xDkOhwNtbW15p+PIkSPYvHkz0uk06uvr0dvbK9rM8yORyIo+kp+97yqdTgMwluZM2XuUhoaGxL4hALhw4YLY+2TSNA1+vz/n+syxKIqCaDQq5mN6ehpjY2MAFi5bHThwAB988IGo8FjNZWtrK6LRqFj+lGUZx44dy/uJNJ/Ph9HRUXHe/A3by2GGQpvNhng8jr6+PjFf+/fvx+XLl5fVz+3eO0s3Z4H/powlq66AsWRmbvb+bATojQCH/Eb7Ib/x2FyKuxuyl9CATGXo7b8a1SWz7f5NxnOAsVH72hfG9zoV+isOiIhWkTQ7O5cGgKKiDYUeC91l5kbqffv2re+PyhMREa0T/GbubwmPx4P6+vqcjdRERES0NFaUvgVisRjcbjfi8fg3d9MxERHRXcCgRERERGSBS29EREREFhiUiIiIiCwwKBERERFZYFAiIiIissCgRERERGSBQYmIiIjIAoMSERERkQUGJSIiIiILDEpEREREFhiUiIiIiCwwKBERERFZYFAiIiIisiCCUnFxcSHHQURERLTuiKDk8/kKOQ4iIiKidUcEpRdeaCvkOIiIiIjWHRGUtm3bhhMnThRyLERERETrijQ7O5fOfuLixYt49913oKoqpqamCjUuIiIiooIpLi6Gz+fD/wFCVJEGoBMU+gAAAABJRU5ErkJggg==)
In this example, we are executing the "GetOrdersByCustomerName" stored procedure with the parameter value of "John Doe". This will retrieve all the orders from the Orders table where the CustomerName is equal to "John Doe".
Stored Procedures can also return values. For example, we can modify our previous Stored Procedure to return the number of orders for the specified customer name:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkkAAACyCAYAAABWSlvHAAAgAElEQVR4nO3df1xUdb4/8NcZBgYYAfMCqYBoASq2GN3UFb8mDdiSbd1WVvuu6+hmlpXZ6s1uundlC+/e7G57Na11TWofMObu6pfqYVv6yGFEe4AbbZnkkIhkxgDqkMrwcxiY8/3jdA4zcIDhhyLb6/l4fB4458zncz7nnJlz3vP+fGYU/nXG3SKIiIiIyIsAgEESERERURea4e4AERER0Y2IQRIRERGRCgZJRERERCoYJBERERGpYJBEREREpIJBEhEREZEKBklEREREKhgkEREREalgkERERESkgkESERERkQoGSUREREQqGCQRERERqWCQRERERKSCQRIRERGRCgZJRERERCoYJBERERGpYJBEREREpIJBEhEREZEKBklEREREKhgk0YhiNpthtVqHuxtERPQ9MDRB0pxMYOepzrJmFxARA7x01Hv5nMzOOmt2ea976ahUp2ubizb0XMezXX0Y8J/53sv/M19a3pupKcC2T9T7uWhD7+159qdr/7u2K9fteqzk7akdL3nfI2KA7INSm57HR26z63FZs8v349wLq9UKURSVkpOT02cdo9EIu92O7OzsbutycnL63d610rUv1zLwMhgMsNls3fbXaDTC4XB49cNsNverTbme0+lUPeb90du5u17kY2Kz2WAwGABI58rzMRHR9aIddAuLNkg37O2PAV8Wdy6PiAGczcD2jdLyOZnAA08DZ0oAe5X0HMseYP8W9XYT5wDv7wSm/FAKBJrqgR2rpHVTU4CfbQJ2PNbZlhy87PkNUJTfv31w1HW2NSdT2qfLtdK6siJpu/owYO2bwIInpD4v2gCEhgPr50h9W7QBeGwbsG0FcHs6sPSFnvtiK5ee11Tf8/GKiAHW75HWFb7V9z7Ix1KuNyezc9u9HWcVBoMBeXl5qK+vhyAIPtfrTXZ2NhYvXozNmzcjKysL2dnZWLt2LWpqapCVlTUk2/CV2WzG3Llzlb4MJ6fTiW3btinH5IknnoDRaITJZOqxjtFoxGuvvYaqqipER0dfx95eH06nE6GhoViyZAksFstwd4eIvscGl0nShwEJM6QbsGeApOZyLSAIQLgPWYyIGCBQD3x8QHo8YdqgutkvZ0qkYGXMOO/lTfVSMDV2ktS/H8wD3v59Z6BT+BagC5b6esc9UmDS32DNk70KOLBdOr5BIb7Xa3ZI/RwfP+BNL1myBKGhodiyRT2wys7OhtPp7JYRslqtyMvLQ3h4ODZt2gRRFOFwOGA0GpGZmYmSkhIlKMnKykJVVRVSUlJgMBhQWVmJAwcOKO16Zg7MZrOyrbS0NK++eK6TtyX3sbKyEkVFRV5ZGoPBgClTpsBkMqkGSF0zNJ79sFqtXpkez8dWqxVFRUXd+m82m1FQUICoqCg88sgjfWZ9HA4HqqurYTabvbYt98tsNmPevHlwOBxYs2aN6rmx2+1ex8HzcdcMmmf/ezp38vqux9loNMJms+HTTz+FKIo4cOAAHA6HV72ezk9OTg6sVqtXu56ZtsLCQiQnJ/f52pOPkXy+Kysr4XQ6ldeSvL5r1s7XjB0Rfb8NLkgKDpUCAznr0pvb7gLq7cA3HsMahqXqw0AJM4EL56RA4bxVquurpS/0b7itq4SZ0t8zJd7LI2KA6CnAZx92Bnp1VZ3rmx1ScDX2FinDVFPR8zaiJwMvF6kPQ3q6XCsd36BRvvd/wjQgLAI4daxzWU/HuQcTJ05EVVUVTCaT103VbDbDaDRixYoVWLlyJQRBwLJly5CRkQGj0Yhp06Zh2bJlqKurw+bNmyEIAkJDQ1FdXY2wsDB8/fXXXtupra3FuHFSMKrT6XDHHXfg3nvvVQKhJUuWwGw2Y8qUKUhLS4MgCCgoKFDq5+TkYNy4cRAEAYIgYN++fdiwoXN4Njo6Gi0tLRAEAZs3b8b06dOxePFi6HQ61NTUdNtvOYN2+vRppc36+nrs2LHDp0N/55134qWXXvLqf3p6OtLS0lBdXY033ngDgiBAp9MpAZpOp1OCkueeew5vvfUWLBYLcnNzodPpkJqaCgBITU2FTqdDbm4uJk6ciPr6+n5nWQwGA+6++27l3AiCgPT0dADo8dyZTCZlKFKuU1JSghdffBGJiYkIDQ1FYGAgCgoK8KMf/Qj79u2D0+lEfHx8n+cnMTERx48fhyAIeOONN5CRkYHExEQAwFdffYXRo0d3CyazsrKg0+m8zs+SJUsASOf73LlzOHv2LFJTU2EymaDT6TB//nw8//zz2LZtGwRBQFpaGiZNmjSsw4pENDIMLkgK/y7j0xNdMPD069LNOWFG9yEmyx7giduk8tw8KSjShwGpSzqDjFPHgNhpvgc7e37T2eZvM72315PQcGnOz85T0pDgy0s7h/ES50jLsw9KmZ2+skO6IKm93tjKpWE6uZ+DyTjJ5EBo1SvAnzZ4Z/bUjrOP5GCorKwMADBv3jxERUUhLy8PoigiLy8PERERiI8feOZKdujQIVgsFlgsFkRHR2Pv3r2YMmWKsryr2bNnIzExUQniHnnkEYSFhSnZF4fDgdzcXADSzTUiIgKXLl2CTqdT3X5UVBQAKHUA4Pjx415t9uajjz5CVlYWLBYL6uvrMXHixD7rOJ1OJSh56aWXsHbtWmRnZ8NkMuHkyZNISZHmoaWkpODkyZMwmUxKYNlfFosFra2t2LRpU7/mPgUGBiI/v/M1WlxcDJ1Oh5tuuglOp1NZd/bsWRw9elR5Xl/np7q6Gnv37gUgvc6io6OV15nD4cCRI0eQmen9AaJrRigxMVE5zp7nu6SkRAmEp06diujoaCUYLSgowC233ILx48f3+xgS0ffL4IKkuipAFLsPTcmczdJcpax7pcBhxf/03eaEaUDEhM6M0NOvSxmcaznk5qiT+qgWRJQVScste6R5R1NTOjNInkOHclbt4teDHu5SjBknHcOWxp77LQeBciBU+Rnwixd9npyt5uuvv+41MCgrK1M+yXfNjKjpKWgYN24camt9yEL2Qs7OyCU6OrrXDEtFhRR834g3yMLCQjgcDqVvxcXFmD59OtatW4dJkyahuFgKfGtra30O3LqaNm2aMs/sWk9YB/p/fjzJAVRkZKSybMOGDaiqqlLak4OqvthsNiUbKZeVK1f2f4eI6HtlcEGSvQr4x0Ep+9LbTVl+XvSUvm/et90l3ejlzIecaenPkNu1UPiWFLDcdpe0P/ZvgPTlnev/76+lZScOA4V7pSE0z2+j9dfUFCkoK9wLfFvduW2gM9t24Vz3euZcKViThw0H4OjRowgNDcWvfvWrbutqamoQFxfX4zfTqqur4XQ6uwUhx48fx8yZM73mpMTExHhlbbqSg6vZs2crdTznJNXW1mLx4sVKm74wmUwoKSlRrVddXQ0AWL5cOq8GgwEZGRk4ffq0cmOXszg5OTnK0FBffM0spaamIjQ0VMmAZGVl4dKlS1i5ciVaW1uVQDQ3N7fH8wNIQ3jx8fEwGAxYsWKFauYsPT0dmzdvRmBgoFdmp+u5k7NPnhmdzMxMXLp0CUVFRb3uz0DOjyeLxYLa2lolm5acnIywsDAlsM7OzkZcXFyf7Vy4cAERERE9Hi8iop4M/icA9m+RAiB5uKrrV9BlH+yUMh+pP+9c1nWuzIREaVjusw+969ZUAHfe61t2ZLBzknoiT6SW+/Hmf0jZMXlboeHSMkAK6vZv6Rxq7NqXnuYkeQ5PrnoF2PVLqa2meuD1tdK2d56S6jrq1L+x9mWxVCd1Sef2+jknyWQyYfXq1Zg5c6bXsMbXX3+NrKwsmEwmZRJy18nNFosFhw4dUtbLk3VXrlyJkpISZZjOaDRi27ZtvX6LCwC2bNmCmJgYiKKIjIwM/OUvf1HWpaeno6qqSmnT1wm56enpXn2RMyoWiwUbN25U9rugoAD19fXKvJ38/HzExcUpfZEzO77Iz8/H3Llzu03c7jonSf6mm+z48ePK3J3ezo/cpjwhftOmTSgoKMBnn30Gh8MBoPtQleccKKDnc7dmzRqEhYUp9cLCwlQnjasd54GcH0+5ubkICAgAAJw4cQKHDh1CWloaRFHE2rVrcerUqT7bKCoqwrZt25Tj33USORFRTwQA4nB3gojU5eTkYPHixVi9enWfASUREQ0tBklENyjPb9vJ2SwiIrp+GCQR3YCsVisSExNRVlaGadOu4++EERGRgkESERERkQr+B7dEREREKhgkEREREalgkERERESkgkESERERkQoGSUREREQqGCQRERERqWCQRERERKSCQRIRERGRCgZJRERERCpGVJAUKQTjc/1ytISsg23U40jSRAx3l2gEs1qt/f5f6dVkZ2ejsrISBoNhCHpFREQ3EnEklEghWPxcv1ycr40VAYhJmgjxSPBDYqQQrDy2jXpcbAlZJ7aErBPfCXpQ1Av+g9rm6oBkcXtg2rDu93xtrNgSsk5cHZCsLNsemOb1+Hr143P9cuV4AxD1gr/4TtCDSl/kx12ftzogWTkvaudG7dxN1ISJR4IfEpM0EV598Kwrvya6trc9MM1re2rn0Gw2izabTTQYDF5976mf8rbkdfLr0LM9q9U6rK8VFhYWFpahLSMmk7TIfzJ2u0pxuP08AKDUbccX7jpM94vAfG0sPtYvxcOtBxHUsBVBDVvxk5Z30SS6hrnXQ+OM+wp+qk1ApBA8bH042WEHAEz368ze3SqMxmhBh/2ucuVxmftbHOuweT0PAHa7ShHUsBXhja8CAH7hfxsA9Hjumn04d9P9IvBn12k4xDbcKoz2WrfeWYighq2IbdyFu/yiMV8bq6zLzs7G9OnTsXHjRlgsFq96D7S83e01pBf8sSvwHjzr0eavAn7olcn87//+b4SFhSEnJ6fPfhMR0cigHe4O+CJSCEa6Xyz+3XkE7wQ9iAztJJS7L+P3bf9AgmYMJmvGYL2zUAmgPK0OSMZkzRg83Vqg+nh7YBoe9U8CAHwrtmBBcz4A4IPgTPyLEAQAyvr1zkK81nYCesEfewLvQ4Z2EgDgUPs5LG19H7cKo/FMwAwAQJp2AjY6P8KLurn4pOMClra+Dz388WHwIkzWjPFqT+7HJx0X8EzAnZisGYNy92Xc07wfAPCV+yr+3lGL6X4R3fZxdUAyXtalKo/lNrcHpqHa3Yg1Acl4u71C2Y8HWt7G4fbzSNJEeO2jvLwnl8RmHOuw4X5tnPK8udpofOGuwyWxWXlc2PENAHg9z1OT6EKV2KAcg/u1cT2eu76k+k3AX12n0ahtw1xtNErb7N23BxfOueuRoBmDw5C2kZmZiZMnT8JkMvm0nRS/8QCA4o4aAFJw9kO/8V7btFgsOHToEDIyMmAwGLoFX0RENPKMiEzSWEGPMve3iNOMRpXYgFlNe3Cyw44GsQ0B8EOMEIIz7sv9bjdJE4Ew6BDe+CqCGrYiuvGPKHXbUeq2I7rxj1jvLFQyIEENW70CJHPHeWV5ldiAF3V3AZCCoxJ3Ld5ur8AzAXfi4daDGC3oECEE4Xe6VCxr+UDJqMzUjPPKRjwTcCfuad6PoIatONZhwyL/ycq6ox1VWKqdBr3g77UPr7WdUPoR27gL6X6xSsbpZ/5T8HDrQSzUxqPcfRm7XaVI0IxBpBCMF3RzcEdTnlLvSf/kPjNV77WfxV1+0YgUgqEX/JHuF4v32s8CAPSCPyZrxuBkhx0nO+yIEUJU24sUgnGXXzTeaz8LveDf67m7SQjEx/qlaAlZh5aQdTgQtNCrnRAhAJXiVXzUbsNMzbhuxwaQslu3aEbjo3YbAMBgMCAwMBDFxcWq2zwQtFDZnpx9StCMQZXYgCbRhdUByXjSPxnPO4uVQE929OhR6HQ6pKamqjVNREQjzIjIJN2sCUaN2Ij7tXF4r/0sbtYEox5ONKENOsEPkzRhA2r3gtiE6X4RKNc/ggXN+Sh1d89EdKWHdCOWh5gAKXh40j8ZgYIWFe4r2O8qx691s7HbVYqLbinLEiuEIU07AYs9Ah8A2NNuBdzSv3e7SpWsjJzpkm/UX7jtqIdTyWrI5mtjvYKHb8UWjBX0SnsX3c1efQKkTEiGdhLOj1rVrZ68fTWeQ24X3c0YLeiUZSl+4xEjhKAJLiVb5Jn5etQ/ScnIyVmrSCG413N3RWzFrKY9ynmZr43Fk/7JAKAEkE2iC5W4CkAKiEpF6bkv61Lxsi5VyQ7KbURFRUGn06GiosJrW02iCz9pedfruP4p8F4lswhI2T4A+EnLu1gdkNytv9XV1XA4HD3uDxERjSwjIkhK0IxBtbsRMzXjcNHdjLnaaJR/l31wih3dhlN8dUlsxu1NuV7DZ30NOw1GQfs3eNJ5eMBzpXLaSvGQ/xTlcaQQjN/pUr2Cjr8G3e9TW7tdpUog5qtLYjN2u0pxvzYO5e7LXkNt92vjkKGdhLpRT3nVkY+lvL3VAclK8FEpXh3QuQv+LouVoZ2kBF4AUOKuVYa/PIcd84IW4J7m/b0GgF2d7LCjwn0FAHDGfRkv61K9hkflIVEiIvrnNSKG22ShQgBu0YxGup+UXUn1m4CC9vP4g+sENgbM6vEnAWKEEOgFfyRpIrAxYFa39XIWYb2zEAkeQyhn3JeVuspzIQU4ciZDL/jjSf9kmDvOo1Vs77HvdrEZ0/0ilAnLA1EpXkW0EIJ5fjEApGFIAYKSrVrkPxnxmpv6bOeiuxkLtfFek5l99VG7DfP8YvCY/3RlqC1SCMYPNOGY1bTHa+hPbchtv6scdWIL5mqj0SS6+jx3aiYJYRgt6BDbuEvZ3qymPapDbjltpQgXgpSJ5NXV1XA6nYiPj+91G4v8J+Oq6ESleBUnO+z4e0eNMmSXpInAPL8Y5bGspyyV2WyGKIqc1E1ENMKMiEzSGfdlJGjGwNxxHn8O+jGedxZjY8AsvN1eIQ2juIGHWw/iY/1SpY48mXq/qxyP+iehbtRTKHdfxkbnR5jhNxZA96EquY6suKMGT/onK9kROZOwqvVDfBi8SJkwvdtVitfaTvR6o68TW7Cs5QN8EJyp1JMnZ/ua4WgSXdjTblWG7ErddhztqFL2e5+rHAXt3/TZTqnbjodbD6rue19ZrkrxKr5yX8UkTZjX8JscUCh97RJMyi6JzXjWWYjf6VKx31WOw+3nVc/dOueRHvswxy/KK4sFdA6ddh2OLHXb8WLbx3jSPxnFHTWwWCxobW1FSkqK1/N6mozfJLrQBBd+2WpRJrp3HcKTzZs3D4AUiHn6+uuvAQATJ07scZ+IiOjGNOy/Q9BXSdJEiLmBCwb9u0csLADE7Oxs0W63i0ajccjaNBgMos1mE3NycrqtMxqNosPhUF3HwsLCwnJDl2HvQJ9F7UcLnwuYxaCJZcCl649JDkV7aj8mabVaRVEUGSCxsLCwjMwy7B3wqXT9xePr/YvTLP98xWq1Dknwkp2dLVZWVg5ZwMXCwsLCcmMU4bt/EBEREZGHEfXtNiIiIqLrhUESERERkQoGSUREREQqGCQRERERqWCQRERERKSCQRIRERGRCgZJRERERCoYJBERERGpGFFBUqQQjM/1y9ESsg62UY/363+O98XqgGRsD0wb0jaJiIhoZBoxQVKkEIwPgxfhWWchghq2YkFzPl4JNCBSCAYAbA9MQ0vIOrSErMPn+uXK8uEwXxur9KUlZN01Dbz0gj/eCXoQ87WxPtdJ0kTANupxrz6+E/Qg9II/VgckoyVkndKe3P4i/wQlQPUsvh5rq9UKURQhiiIcDgeMRiMMBgNsNhtycnKU52VnZ8Nut+Pdd9+F0+lU6sjFZrPBYDB4tee53Gg0wm63Izs7W2kzJycHNpsNn376abf2RFGE2WzuxxEnIqLvixETJC3yn4zdrlIcbj8PACh12/GFuw7T/SKwOiAZMUIIwhtfRVDDVux2lWJX4D3QC/7XvZ+rA5Lxp8B7MatpD4IatiKoYSuebi247v3oTanbjujGP2JW0x78vaMGsY278JOWd9EkugAAZ9xXsFQ7zev4XRWduL0pF0ENW7HeWYjdrlIENWzF7U25uCQ297o9s9mMsLAwpKWlQRAElJSU4MUXX0RycnKPdfLz86HT6SAIAsrKylBQUABBEBAdHQ2LxQIAyrK0NCkI3bFjR6/9ePbZZyEIApYtW4a6ujps3rwZgiAgPT3dp+NGRETfLyMiSIoUgpHuF4sP2r/CO0EPKhmMTzou4F/9xuKn2gT8xlmk3OT3u8oxWtDhVmE0kjQRyA1cgOcCZinZj9UBnTdnOXPSErIOL+tSvbbrmZ2SMy2AlCnaHpjmtX6+NhZ6wR/pfrF4uPUgSt32bvvRNYMj9yNSCMaR4IeU4UPPx5FCMN4JehC/1c3tVm91QDLqRj2FDO0kHAhaOGTDkEc7qmATG3CrMHpQ7QCA0WjE9OnT8eabbyrBTW5uLnQ6HaZPnz7o9gHAYrHg9OnTCAsLQ2Ji4pC0SURENCKCpLGCHmXubxGnGY0qsQGzmvbgZIcdDWIbQhAAALggNinPb4ILV0UnbtZIw0Bp2gloRBuCGrZiVtMe/FSbgEghGKsDkpHuF6tkoNY7C5U2Vgcko9x9WckGmTvO4xf+tynrH/VPwnvtZxHUsBUPtLyNJ/2TESEEY7Sgw0V398xKkiYCpqD7sKA5H0ENWxHbuAuP+if5NEw2SROGRM2/ILzxVa/+v9Z2AuGNr+JQ+zk80PI2ghq2Irrxj6oBWn8VdnyDlQFJg24nPj4eAFBRUaEsq66uhtPpRHh4+KDbBwCDwYApU6bg9OnTKCsrG5I2iYiIRkSQdLMmGDViI+7XxuG99rO4WROMejjRhDaf6le4r2C/qxyANNR0d/Nf0QQX0v1i8QfXCSUDJZMzQi/rUr2yTJM1Y5TnHGo/h+KOGgDA4fbz+EnLuwhFAMYIQT3uw9GOKiWAuSQ241iHDQkebfbkitiqZMrkYHCsoPdp3wequKMGYdDhB0M8OX4opaWlQRRFFBQU4PTp0xw2IyKiIaUd7g74IkEzBtXuRszUjMNFdzPmaqNR7r4MAGj4LlAaK+iVuTF6+PeY0fGVQ2zDrKY9/crKXBCbIEKUMljuAW/6htAkurCn3Yp5fjGDakfOIMkZJQCIioqCTqdDXV2dah2Hw4Hq6uo+2y4oKPA5MKqvr1eG+4iIiHwxIjJJslAhALdoRiPdTxqiSvWbgA9cX+ELd53X0NCvdbPxhbuu1wCnSXShSmzA/do4ANI8I3lOUpPoQj2ceEE3p1+Tvy+JzdjtKsXvdKndvvF10d2MeX4xynyhJE0E5vnF4KN2GwDgJiFQGR78tW424jU3+bRNeT98yUj118kOOzK0E3GLZuBzk0wmEy5duoTMzExl2YYNG3Dp0iUsW7YM9fX1mD17trIuMzMTra2tAw5o5KG8lJQUANJQXEZGBmprawe8D0RE9P00IoKkM+7LiNKMgrnjPP4c9GP8vaMWGwNmIUQIQKnbjo3OY4gRQpShsRghBBudx/ps97+cx3GXXzRaQtbhSf9k/Kzlb8o6uX7dqKe8Jmf35bW2E9jtKsX5Uau8fgKg1G3HeucRfKxfipaQdfhYvxTrnUdQ6rYrwZU8+bra3YiC9m98Pj45baXY+N3EdF8mbssTyD/WL8UP/cbj/KhVXhPTZZfEZvy/9jNI8DFg68maNWsQFhamfOU+LCwMa9as6XPdQFgsFmzcuBEzZ85UhuLq6+s5FEdERP0mABCHuxN9SdJE4JmAGXjSebjb/CEiIiKia2FEZJIqxasIFQKUb5fpBX88FzBrWH4HiYiIiL4fRkQmCej8xW35G2brnYV4re3EMPeKiIiI/lmNmCCJiIiI6HoaEcNtRERERNcbgyQiIiIiFQySiIiIiFQwSCIiIiJSwSCJiIiISAWDJCIiIiIVDJKIiIiIVDBIIiIiIlLBIImIiIhIBYMkIiIiIhWDD5LmZAI7TwGLNqgvl8uaXYPeFBEREdH1oh10C4lzgPd3AlN+COjDgKZ6YGoK8KOVQNa9gL1qCLpJREREdH0NLpMUEQME6oGPD0iPJ0yT/o4ZB+iCB9k1IiIiouEzuCApYSZw4ZyULTpvBW67S1pelA/YTgPZB4H/zJcyTEREREQjyMCDJH0YkLoEqKmQHp86BsRO6wyIdqwCnrgNOPMJ8HIR5yQRERHRiCIAEAdUc2oKsOoVQBfUuczZAuz6JfBlsfdzI2KANa8Df97cfR0RERHRDWjgE7dvuwuo/EzKGMkWbZCWdw2Ewr+bu0REREQ0QgwsSNKHAQkzgMK93strKoAHngaCRgGzH+xc3lOGiYiIiOgGNfDhNiIiIqJ/YvzFbSIiIiIVDJKIiIiIVDBIIiIiIlLBIImIiIhIBYMkIiIiIhUMkoiIiIhUMEgiIiIiUsEgiYiIiEgFgyQiIiIiFQySiIiIiFQwSCIiIiJSwSCJiIiISAWDJCIiIiIV2gHXjIgB1u8BQv+lc5llD7B/C6APA9a+CURP7lxnKwe2rQCa6ruvd7YAu34p/XvVK4AuyLve62uBx7YBoeHAy0sBexUwNQX42SZgx2PSYyIiIqIhNPAgCQCczcD2jcCXxZ1BS+FbQLNDWr/nN0BRvncdObj6x0Hgt5nd21w7o3sApA+T1rW1AKk/lwIxIiIiomtoaIfbHHWdAVJPUn8uPe+Dnf1v/+P3gLGTOoMmIiIiomtkcJkkXTDw9OvSv+UhM3k4DQCWviAVoHO4bewk4Mwn0vMWbQAMS6X1almnrq5cACYlAbenA5drB9V1IiIiot4M7XDbw1uAP20AvrFK6/sKfPZvkTJKa9/0fZvmXOC+J6T5T0RERETXyNANt31jBertwJhxvT/vwjkpmzRQXxZL2xkfN/A2iIiIiPowdEHShGlAWETfw2CnjgG33gHMUZm07auyIuCuhwZen4iIiKgPQz8n6cvi3uckfVksPW/VK53rnC1ScDU1xfsnALIPdv4EgKfPzUDqEuknAYiIiBERngYAABQwSURBVIiuAQGAONydICIiIrrR8Be3iYiIiFQwSCIiIiJSwSCJiIiISAWDJCIiIiIVDJKIiIiIVDBIIiIiIlLBIImIiIhIBYMkIiIiIhUMkoiIiIhUMEgiIiIiUsEgiYiIiEgFg6TrLEkTAduox9ESsg6f65cjUggesrYjhWAcCX4ISZqIIWuTrj2DwQCbzYacnByv5UajEVarFQaDwWt5Tk4OrFbr9eziDcdoNMJutyM7O3u4u0I0YNfyfkBDY2QFSWt2ATtPdZY5mdLyqSnAtk+81y3aIK2LiAGyD0rP6aq3eoDUvue6NbvU6+w8BfxnPqAP67X7SZoImILuw4LmfAQ1bMWzzkLsCrwHesHf683SErIOqwOSh+ig9Z9e8Mc7QQ8qfbGNevyaBl7ztbF4J+hB6AX/a7YNTytmA22vdJa/PfFdP6YAV37Xufz3Czuf/4//AMZ4XL/+9oS0Xm5Lfq7nur894b0duayY7d2fHTt2oL6+HitXrgQgBQAOhwOLFi3ClStXsGPHDq+gSH6e2Wz2fad7e60v2tDza1kfJj3uui4iBnjpaGcb8vN8eB/IQaEoihBFETabrVsgeMOS91O+9sjmZAJr3+i+bmqKdP2JiBn4Oeh6HfK89vUhJydHOc6iKA46uO4poL/ezGYzRFFU+nGj9Ks/ersfAMD2wDTlGtwSsg7ztbGD2p58XR9sO0PRB8+AMEkTgSPBD92wAaJ2uDvgM/li8sRt6usddcCOxwB7Vf/a7aneog3ShWj7Y8CXxd7r1s6Q/q7ZBVw4B+zf4tOmVgYkYb3zCErddgBAcUcNlmqnYYZmLLYFGvBw60Ecbj+PSCEYHwYvwhn3ZRxuP9+//RkkedvHOmwIath6Xbd9PciBzX07gcOnO5ffEg68uRR45m3gzePS46NrAWtt321eagDumwa8dgz4qq5z+Y93Sn/nTwF2LAIW7PReD0g3sbCwMCxbtkxZZjKZYDKZYLVakZiYiDfeeEMJjGRbtmzB//7v/yI7OxtZWVm+7Xxv75GyImDHKunGvPZNYMET0ut6xf9I9Z747qa8Zpe07C//Bdi/AUZHSnUmTJOep+v7QicHhdHR0QAAq9WKHTt2YNq0ab7tx0g2kHMAALZyYNsKoKne502ZzWbMnTsXmzdv9v01MoI0NDTg7rvvHjkBdhc93Q9uE8KxIXAWACC88VU0ia7h7OY1US86sch/Ml5rOzHcXenTyMkkjZ10/balDwMSZkgXqK4B0gAlaSIQBh3Ouq/ic/1ytISsw57A+1Dm/hYL/eNxrMOmBESXxGbsdpXifm0cAOkThdF/mlLPMwqPFIKV5edHrUK85iavbXpmp+RPEHrBH7mBC2D0n6aslzM50/0icM5dj43OY6r74fnpxrMfqwOSsT0wTXme5+PVAcn4rW5ut/7LfT8QtBAZ2kmoG/UUWkLWebUzlMYEA/PipEDIM0ACgNV3ASerpQAJkIKZfZ8BC2/vu90LDuCjSiA1vn/9MRgMyMjIwKFDh2CxWJTlciapsrISRUVFmD17drdsi8lkwsmTJ5GZ6VtGwWdN9dKNfOwkKfMRMUEKiGTmXGlZ3B3S46sXpQDp1mTgXGmfzWdnZyMyMhJbtnR+sMjPz0dkZKQyvHjgwAE4HA6IogiHwwGj0Qig87iIooi8vDyEhoYqbXiuE0VRybIZDAZUVlbiwIEDcDqd3TJXXTMtfWbn5OOj5tI3fe6/TzzPwQAZDAZMmTIFJpNJNUCyWq1e++r5ODs7WzlWntkns9mMgoICREVF4ZFHHoEoinA6ncqQZ9d6cntWqxVFRUVwOp2wWq2wWq1eWaCu9TyzQ72du6qqKly9ehWpqale+9b1tSC/hoxGI2w2Gz799FOIoqi8zjxfY3KGqutrb6j1dj+Yro3AaEGHVa0fdguQuk6p6Pq46zXf8xpcN+opZGgn4UDQwm4jBPO1sapZq+2BaXguYBZsox7H9sA05fovr+/pHpOkiUBu4AI8FzBLdXQkx/UFJmvGdBs98Lyfed4r5PZyAxfANupx5d7lOQLheW8aypGJkRMk/eW/gOgp3YfEZKHhUlpbbdisN2r1gkOlT8SXfUgj+OhmTTBK3LVYoL0Fu12leKDlbVSJDWhEG6KFUJS7L3s9/4z7MmKEEOVEPxNwJ+5p3o+ghq041mHDIv/JStbnWWchghq2IrZxFyrcVwBIL7YXdHNwR1Oesu5J/2QlqAkVArBQG4/JTW8gvPFVAECK33gkaMagSmxQ/fQiv+GCGrYiqGErdrtKvdLDvfn3gDuVfsr9vyQ24/amXDzQ8jYOtZ9DeOOrCGrYiqdbC3ptq+twja9DCaODgVE6oOpK93WTbwbKL3ovs9YCY0MAfUCfu4dDZcCymd5Dcn2JiooCABw9etRruclkQmhoKPbv34+bbroJa9asQXR0tFcgBQDFxcVKcOGTrq91tSGbiBjpffbZh8CYcYCzGWh2dK6v+y4DEvrd8Gvl58Btc4ExY4EvCqX3TXBo93a/M378eDidTlRXVyvLKioqAADx8VKUmZqaitWrV0MQBFRVVWH58uUwGo147bXXsG/fPgiCgGXLlsHhkPplMBjw/PPPY9u2bRAEAWlpaZg0aZJy89bpdLjjjjtw7733Ii1Neg0vWbIEBoMBd999NzZv3gxBECAIAtLT0307luPjvYfSxntEyEtf6DzGT7/unV3z5TrleQ5k0ZOBl4t8Hm6LioqCTqdDTU2Nb/vjITMzEyaTSTkmcoYvPT0daWlpqK6uxhtvvAFBEKDT6ZCVlYXs7GysXbsWL730knJ+Zs6cqQQ8P/jBD2AymRAXF4fa2lqUlZVh4sSJMBqNWLFiBVauXKnUy8jIUF7TPZ072YkTJ7p9UJDfP3L/S0pKsHz5cgBAaGgoAgMDUVBQgB/96EfYt28fnE4n4uPjkZOTg3Hjxin19u3bhw0ber+PDPRa1Nv94CYhEFdFJ5rQ/wzSyoAkPNx6ULlGy9fS19pOILzxVRxqP4cHWt5GUMNWRDf+EaVuO+ZrY/E7XSpiG3chqGErZjXtwcu6u5UA6mf+U/Bw60Es1Maj3H0Zu12lSNCM6fMek6adgEa0KW3+VJuACCEIAHBBbAQg3XM8yfcEz3vMIv/JSnsl7lq83V6BZwLuxMOtBzFa0EEPf6wOSEa5+7JSz9xxHr/w72HUqZ9GznCbvQp4bl5nKnrnKWDPb4CifGn9UA63TU0BAvVD13cACZoxqHY34ifaePy+7RPM1UZ3C4x6s9tViktiMwAoL/z52licc9ejuKP7hXC6XwQytJNwftQqZdm3YgvGCnpUilcBAH9wnVCCoZ+0vAsAuD8wTnX7esEfYdDh922fKMs+arfhp9oE6NF3kLTbVapkysrdlzFZM6bPOj2xWCzKUE1/3BouBUnXwpEzwMOzgQen+14nPj6+W8DgSR5260lFRQWcTqfvG+ztPZI4R3pPAZ3vK1/mvZT/HZizULqhewZTg1BSUqLst3yDzsnJgcPhwN69e7s9PzU1FdHR0di0aRM2bdqkLB8/vvMC7Jmt83zttLa2YtOmTUhJSfE9QLpwTvobFCId04SZ3us9r0tTU4Cfdfap3+dA1s/htvj4eOh0A3ux19bW4pFHHsHs2bN9HgIdP348qqqqlKyVyWTChg0bMHHiRADSOa2pqYHD4UBubq4SfMybNw9RUVHIy8tDXl4eAKCtrQ3x8fHK+0Lt3MlZqr179+Luu+/GAw88oPTFYDAgLy9P+RACAGVlZQAAp9OJ/Px8pKSk4OzZszh69Cj+7d/+DQAwe/ZsJCYmQhRFpV51dTUMBkO3DyiygV6LersfRAmj+t2erNx9GQeCFmK3q7TPD5ueffG8v1SKV/GV+ypu1kjBzm5XKS66m1HhvoL9rnL8WidNquztHgNAeT4AlLrtuLv5r14fqHPaSvFMwAzsdH2uLNML/tgTeB8ytJ1Z1N2uUnwEm9f25T4BQLCgRbpfLDK0k/CyLtWr3lAYOZkkWVM98NtM6SKSuqTPSaIDUlcFiKL0SXqIjBdGoQltCBUCcEFswmTNGJz57k1hEx3dgobeMjq+2u0qVSJrz08OvSnvksG6EQ3001tlHSACiLmp+7ryi1I2ydO0ccCFBqCpTb29rvOVXjkC3DPF9/24oZQVSfP9LHuk7MbUFCmT2jUzFB4j/RUEKcvUVC/No/G8ofeipqYGOp3O6wYmZ5DkjNJA2Gw2pKWlKVkAQRC6zeNSM23aNAiCAAD9n9g87f8Ax9+VghsAqK0cSNc7qZ2DAZKPpWeg6Kv09HQIgoDjx49fl4n1ZWVlXudNzk75wmKx4MiRI5gxY4ay7Fe/+hUAKK+HggLfggUASoZMLmoZXE8DvRb1dj+oFhsxSRPm04fPrl5rO4Gghq14r/3skA87qRnIPUZW6rbDJjZ4TRGRsz/yqMJ6Z6FPbTnENsxq2uPVF1+DxL6MvCBJNr6fE0D6w14F/OMg8MDTUup7CI0WdJjuF4G7/KKhRwAma8Yg31WBeX4xXuPKj/lPR05b75HwRXczbtGMxq3CaOgFf+wKvEd5wV10N2OhNr7f32TY7yrHJE1Yt1Rlk+hCPZxYGZCkLFsZkIQv3HXKJxA5uErSRGBjwCyft3nR3aykTX0hf3rzvJh5Dgv0RJ5n9MJ90sRsT4fKgNujpEnWgPT3oTukwKfqCjA2FPjXCZ3rbo/qPmz36TfS826Pgk8qKiq6BQz90VcmakAK35KCn9vuAr6xSv9O/bm0Th8GLHwG+OIo0OB7FtSr+cJCOJ1OZfjDYDBgxYoVOHnyZK9Zs5qaGoSGhiI1NRUGgwEvvviiMiepoqICERERys1xINLT07F582YEBgb2HRDUVEhzFgHgc7OUdU6Y0Xud/vA8BwNkMplQUlKCxYsX9zgcO26c9CEwJycHiYmJ3davXLlS+UKB/Bq1WCyor69XMkSympoaxMTEeM1PiomJQXFx73M6a2pqEBcXN6hvpR09ehQJCQnK62HcuHGor6+HxWKB0WjEzJkz+2hBUltb2+vxUjPQa5FM7X7wV9dpnHPXKxmbrm4SApUsz691s72CDNnh9vOIbdwFAMp1tUl0oUpsQEKXD+Rn3JfxqH+SMkyW4jcekzRhONnRe7Az0HuMp8KOb7A+oPO9M9kjORApBONR/6ReakuaxXbUw4kXdHOuSUA4MoKkrl9D3nlKuih5pp97G+vXBUtzA9S+XttTvf1bpEDJc92aXQPehZrvxmC/cNfhT4H34s+u0/hz0I9R7r6Mox1VWO88go/1S9ESsg4f65d6feuhJ6VuO153ncTH+qWoG/UUcl1WFLR/o6x7uPWgMknP108Vl8Rm3NO8H4/6J3X7CYCNzmOIEUKU5TFCiDLBWw6u6kY9hbygBdjo/MjnY1PqtuMLdx3Oj1p1TSduA9Kk7X2fAac3ef8EwOHTQNb7wPvffW3//Sekx4dP977O0+VmIK8EiAzxrS9ycDNv3rwB7UtKSgpaW1t7/aTbb/Yq4MB24M57pQzS62ulf+88Jc2JcdT1/m1OXXBntkmFxWLBxo0bMXPmTIiiiIKCAtTX1/c51JWVlYWSkhJs2rQJBQUF+Oijj2Cz2QBIAcG2bdswd+7cfk267TrB97nnnsNbb73l2/GMngx89bl0/blwTprMfvVi3/V8mZPkeQ7kD2n9nJMESIFfSUkJ8vLyumU48vPzERcXB1EUkZGRoQQzXTMjeXl5OHTokFcAm5+frxxreeJ2VlYW9u3bh02bNkEURWzatAn79u3rMyOUlZUFk8mkTAQfSOZK/hJDSEhIt33LycnBF1984VM76enpqKqq8jpe/fqZjX7o7X7wtduBpa3ve11r5UnR8pd65Ot6tbtRueZ3/emW86NW4Q+uE8qHWEAa4tr43WRq+bp+uP08drtKlevvnwLvxbKWD7zqqRnoPcZTcUcNvnJfxU1CoNK/hdp4tISsw2f6Zfiz63QfLUjk+5D85Z+h+MkETyLLtS/ztbHi9sC0Ye8Hy41VcnJyRJvNJhoMhn7VMxqNot1uF7Ozs4d9H1hYWPpXeD8YUWXYO/C9KJFCsPi5frk4XxurPP6PgJnD3i+W4S9Wq1W0Wq39rmM2m4e97ywsLP0vvB+MnDIyhtv+CVwSm7Gs5QP8KfBeJRV6wu1Dep7+6a1ZswaBgYE+/xcb8vwNn7+NRUQ3FN4PRg4BUrRERERERB6YSSIiIiJSwSCJiIiISAWDJCIiIiIVDJKIiIiIVDBIIiIiIlLBIImIiIhIBYMkIiIiIhUMkoiIiIhUMEgiIiIiUsEgiYiIiEiFdlC11+wCEud0PnZ8C7y8FEj9OWBYCuz5DVCUD+jDgLVvAoV7gfHx0rqudexVg+oKERER0VAaXJAEAJY9wP4t3Zc3XAZmPwh8bu6+rqwI2LFK+veiDcD6PQyUiIiI6IZy7Ybbqr4E6u3AhGm9P++DnYCjDkiYec26QkRERNRfgw+SDEuBnaek8tJRICKmc11ZEZC+vPf6TfVSkDQ+ftBdISIiIhoq1264DZCG2mY/CEz+4aA3Q0RERHQ9XdtvtzXVA8ffBW77Pz0/Rx8GhIYDNRXXtCtERERE/XHtfwLgTAkQdycQFqG+fsX/SH/VJngTERERDZPBD7cZlnZ+pV/+Or8nexXwxVHvr/0nzpHmMAHSvKXfZg66G0RERERDSQAgDncniIiIiG40/MVtIiIiIhUMkoiIiIhUMEgiIiIiUsEgiYiIiEgFgyQiIiIiFQySiIiIiFQwSCIiIiJSwSCJiIiISAWDJCIiIiIVDJKIiIiIVDBIIiIiIlLBIImIiIhIBYMkIiIiIhUMkoiIiIhUMEgiIiIiUqEJDw8f7j4QERER3XA06enpw90HIiIiohvO/wf2Qy/YjyyHdQAAAABJRU5ErkJggg==)
In this example, we have modified the Stored Procedure to accept two parameters. The first parameter is the @CustomerName parameter, and the second parameter is an OUTPUT parameter called @OrderCount, which will be used to return the number of orders.
To execute this Stored Procedure and retrieve the @OrderCount value, we need to use the following SQL code:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkkAAABgCAYAAAAJvObjAAAdzklEQVR4nO3df1xUdb4/8NcZmBlmBgYiBkVAtBQ3MTZqw0s+XGkgH1Q3H91Yba8XtKu2bZGmN/emFZjUPqpd94GpbZrYvQjfbunFvtdu5iaQ1gPd2G+ZFKapK8QPf0AqAwMMA3O+fxzPmRk4wICjVL6ej8d5MHM+53zO58zI8D7v9+eMAgARRERERORFM9oDICIiIvohYpBEREREpIJBEhEREZEKBklEREREKhgkEREREalgkERERESkgkESERERkQoGSUREREQqGCQRERERqWCQRERERKSCQRIRERGRCgZJRERERCoYJBERERGpYJBEREREpIJBEhEREZEKBklEREREKhgkEREREalgkERERESkgkHSICIFI740LURnyAo0BP8WiRqLX/vfEJSGHF2SX/skIiIi/wgc8Z6WWGBlCWC+0b2uogTY+Yr0eOkWYOoMd5vte2BdFtBcr95esgaoLAXmrgLGTgQ2PqZ+3LmrAGuWe3sAuOUu4LHXAL1Beu7oBLY8BXxzEDCFAsvfAmKmuPtoOA6sXwTYWwc8vUjBiI+Mc/E7x37s66lDosaC14KseLjzfZwXO7AhKA2PahMBAMddFzC7YyfOix2+vHJ+d09gHHYbHlKeb3VWY1lX+VU5VqRgxLuGB/BUVwWqXc0+7ZOosWCPMRM3CgZl3d6e08jq+gCPaKdhnT4Vczp3YV9PHUyCFiVB9+PtnqN4TpeCKZpwr75G+7UmIqLrx8iDJABwdAAbVkvBiBw0Ae5AyTNokslBCwCsnDFooNKPKVQKoD54A7h9tjtIAgBbC7DxN1IQNncV8NDTwPoad7tnUOWDudop2Oqsxr6eOgBAtasZX7la8PMAC+I14YgVQhDRvgl20YkcXRK2BM1GVtcHsItO38/HD3J0SVitm47p9hKfg5ZrrdrVjJj2zf0CTdm3rovICkzAwd4mZd0l0YHb7EUApHOcogm/aoEfERGRGv+V25rrgd0bgPg7pWBmIOMTAL0ReHP58AIked8uO/DZbsAcIQVmappOSO1G8/D6vyxSMCI9IA57ev6O9wwPojNkBb40LcTfes/ijoCx+FVgPNY4KpWAaKfzOMIEPW4WwpCosaAo6D48o5uOzpAV6AxZ4VVS2xCUpqyXM1Fqbe8ZHoRJ0AKQMkUbgtK82u8JjINJ0CI9IA7/2vWhaoCUqLGgIfi3/cYRKRjxsfFhpXzo+TxSMOI9w4P4vX5mv/02BKWhLvgx/EPAOHxmylJel0jBOKLXWXagtx4NYhtuFsKuqB8iIiJ/8u+cpAtnpABIDk6sWcAbX0vLqwekoCY8SspAddiG3/+0XwJHK6WAzNYCxCerb3f7bKDhmLu0BwBZa91jea500EBurGDCUdf3mKQJQ73Yhun2EhzpbUab2I0Q6AAAZ0W7sr0dTlwSHRijkYKFtMDxaEc3DG0FmG4vwa8C4xEpGLEhKA0AYGgrgKGtAFud1UofObokHHddUNrKeuvwiHaa0v6oNhHv95yEoa0Aczp34QltEiyCEWGCHudc/UtPiRoLig33476OUhjaChDXvgWPahNxT2DckC/zRE0opmpuRET7Jq/xL+sqR1z7Fvy1twnT7SUwtBXgNnuRX0pf+3u/wxJd4tAbEhERXSNXVm4bilq5LfVfRtaXJRa4dRbw9SfS8y8+8i65mSOA/A+lx0cr+89pGka5bYzGiCaxHQ8ETsL7PScxRmNEKxywo9un/U+4LmKn8zgAqdR0d8e7iBSMuFUTgae6KvptL2eEMgInYp0+VVnvGUTt7TmtlKP29dQp86TCPeb59D2HA731SobpvNiBT3obEK8Jx5HewctyF8UuJVN2FlIwOFYwXdV5QAd7m5AVmIBb/Tw5noiIaKT8GyT5kiVqOgH84l4p2zScclt8shQoLXvTvc72vbvkJs9JioiVJnHPXdU/QPP1UJpwNLrakayJwjlXB2YGxuC46wIAoO1yoOQZNJigHTCj4yub2D3seUVnRTtEiFIGyzXiQ/8g2EUnSnpqMCtggBIqERHRNea/ctstd0mByf63Bw9+viyTAppfPz+8/m+fLWWmHp/mXhqO9S+5fXMQOPXF0HOjfGAWdLhJE4b0AKlElRowHnucf8dXrhav0tDz+hR85WoZNMCRS3IzA2MASOU1eU6SXXSiFQ6s1c9Q5iH54rzYga3OavxRn9pvXtA5VwdmBcQq844SNRbMCojFpz0NAIAbhCClPPi8PgWTNTf4dMy+pUV/OtLbjIzACbhJw7lJREQ0+q4sk6Q3ujM7nrfdy6xZ0gJ4fwXA+kXSHW5vfO3e1rMcNnWGd9v/vAZYxgNlRd7HP3saSJ0P7Nnsvf6dl6Q77W5Ll4IyQJqTlLVWejzEVwB867qAeE04ynrr8F+Gf8QLjoNYrZuOXT0nUO1qxmrHJygJuh+dISsAuG9nH4xddGKNoxJ7jJlYp0/FVmc1Vjr2K+1yny3BTyrr5NviB/N692EAQF2wu7wofwXASsfH+MyU5dWfHMhtdVYrXxvwguMgynu+G/Q4nufxZ+dhZV9fbsnv+xUAdcGPqb5m58UO/HfPt14lRyIiotEiABBHexA/NIkaC57W3YknHPuu+S39RERE9MPAb9xWcUq8BLOgU+4uMwlaPKObPqxSGBEREf24MZM0APkbt+VvfF7p2K+UtoiIiOinj0ESERERkQqW24iIiIhUMEgiIiIiUsEgiYiIiEgFgyQiIiIiFQySiIiIiFQwSCIiIiJSwSCJiIiISAWDJCIiIiIVDJKIiIiIVDBIuopqampQVlY22sOg68mz2cAfHgeCDf7pa+G9V97PtWC9A9j+HJB4s9+63BCUhs6QFegMWYEcXZLf+gWAHF0SNgSl+bVPIvK/kQdJS7cAb3ztXl49AFhipfXPlQKmUGk7S6zUNneVtO65Uu/9PLft277+b8Atdw05lPz8fDgcDoiiCFEU0dDQAKvVOuR+hYWFqttarVY0NDQMu7+rpaamRhmLKIooLCy8asfKzs5Gc3Mz8vPzvdaXlZV5jcFmsyE7O9unPkf6/gymrKwMNTU1V9THlZJfE/n9kP/dXM33Z0iNLf3XJd4sBRDvrpWWN38HjAm/9mOz3uEew7tr/RvUtFwCupz+6QtQAhhDWwEi2jchPSAO9wTGKW1y8PSlaSEiBaPfjjtc9wTGKWPpDFlxVQMvk6DFe4YHldfBV4WFhaqfX31/hz1/f/p+5nnuO9BnkdrvX35+Ppqbm7F582bYbLZ+/Q3nc4yuT1eWSaooAR6fJi3PzAKa64G3/l1qu+9x6eevnwcajgE7X3HvV7LGvd/vMwF7qxRM5e0GbC3utuV3At8cHHQIhYWFeOaZZ/Dqq69CEAQIgoCYmBhUVFSM+LQ2btyI1tZWpb/W1lZs3LhxxP2NlPxLHxoairS0NGU8S5YsueZjAYCjR48qY6ivr8fChQuH3KewsBC5ubkoLi722/vzQ9LW1oa77757VIPoIVWfAhb8Hnh4DbDsNeBS++iNpe4ssPgVaSz/uRdY+Wu/Zn/8IVFjQSj0WO34BABgF534s/MwHgichBxdEmKFEES0b4KhrQBbndXYEjQbJkF7zceZo0vCfwTdi+n2EhjaCmBoK8CyrvJrPo7B5OfnY968eXjxxRchCAJefPFFzJs3r99FWF8JCQnK9i0tLViwYIHXZ1/fz6KXX34ZSUkDZ/sqKythNpshCALKy8uV/c1mM4qLi/16zvTT4v9ym70V2PUnYEamlFWK+RnwzktD7xefLAVIcpDlA6vVioyMDHz66afIy8tT3cbzqkO+asjOzobNZsPixYsRHR2N8vJyiKKImpoa5OfnIzIyEq+84g7qSktLERkZiezsbOUqx/NKx/PKxXP91KlTlfXyMeU2zzJcTU0Ndu/erbTL40xNTYVer8fq1atVg4q+GRq5T/nqSb5C8nyen5+PU6dO4dSpU/3GX1NTg+3btyMiIgK5ublDXmnV1tYq5+X5GhQWFir7paSkoLy8XDWw63sl6fm8bzZP7k8+57S0NEydOrXfuQ+UBSwrK8Pnn38Om82GhoYGVFZWeu03kvcHAOrr63Hp0iWkpqb2O7+BMoA1NTWorKyEw+Hw+rckt/d9X4eVmSr6EPj3N4D2Tt+2DzZI5Tk5u9O3VBduljJPfduezQYef9CdoRpJia/ic+DYd0BSvPS8b8bLs9Q3Jtw9jr5tgBQI/uYP0s8rtESXiJKeGjyinaZkaMYKwTAgEPMCp2CNoxJ2Ucpa7XQeR5igx81CGBI1FhQF3YdndNNVy3Q5uiRl/Tq9978Xz+zUe4YHlaDrnsA4bAhK82q/JzAOJkGL9IA4/GvXh6h2Nfc7Bznr07fPSMGIj40PI1FjAQCv55GCEe8ZHsTv9TP7jT9Hl4SW4CeRETgRuw0PoTNkBRqCf6v0M5DMzExUVVUpn895eXmor6/HXXcNXSHw1aFDh2A2mxEREeG3PolkVxYkWbP6l9sAKftTWQpMnQHs3iBlmDxlre1fbhs3WQqS7K0+Hz46Ohp6vR4HDx70+uMo/xErLCxEVFSUcsWxY8cOrFq1CsXFxTCbzdi2bRsaGxuVLE1CQgLGjRsHh8OBxsZG5TgnTpwAAEyePBkAMHXqVBw6dAiCIGDbtm3IyMiA1WpV/sDLxzt69Kj0MlmteOGFF7B+/XoIgoC0tDRMnDjR62oqNTUVOTk5XlkatbHI8vPzsXz5ciWDtmDBAiQnJ/v0BzUmJgZdXV39xp+QkIAFCxagpaVFufLzvNLyDEoAYMmSJSguLkZVVRVSUlKU/lNSUlBVVYXGxkaEhoaitrbW5/dUNn/+fK9snjyOvLw86PV6r6tBQRCQnp4Oq9WK7du349ixY6pZwGnTpmHHjh0wm80ICwtDeXk5oqKiRvz+yA4fPozMzMx+5yBfDctXxJ4Zp1tvvRXFxcWYNGkSzpw5g6NHj2LChAnIzs7GokWLsGTJEuV9zcjIuDolgWADkPcIUFMrZXYeXiNlmZb9yr1N0iRg0y4p+wMAye7AHykJwLp31Nt81dgCREdIAdKTmVJ/csZrxjSpRBdsAHL+SRrHw2uk49087qpkoOTg5KzLjvSAOEy1v4UdzuM4K7bDKARKbaJd2d4OJy6JDozRSCW3tMDxaEc3DG0FmG4vwa8C4xEpGJGjS0J6QJySgVrp2K/0kaNLwnHXBSUbVNZbh0e005T2R7WJeL/nJAxtBZjTuQtPaJNgEYwIE/Q45+pQPYeSoPtR1lun9FkvtuFl/S+HPP+JmlBM1dyIiPZNXuN/vfswIto3YW/Paczp3AVDWwFi2jerBmgyq9Wq+vt/5swZREVFDTkWX6WkpKC+vh779u3zW59EMv+X22RjJ0o/x03uv59auU3efqRDqahATEwMXnzxRTgcDgDSL4/nH/bFixcjNDT0iksjjY2NePvttwFIgUJMTAyio6MRGRmJ0tLSftunpqYiJiZGyc6Ul5fjpptuwrhx45RtqqqqlGAkISEB6enpmDBhwoBjGDduHOrr65UrtOLiYtTX1w+6j8xmsymZsqamJuj1ekRHRw+5n2dQAkAJCouKihAaGqpk6UJDQ1FUVITo6GiYzeYh+1XT1NSESZMmDWvOgHwORUVFyrpDhw4hNDQUN9xwA06ePIkDBw7A4XB4vU8jfX9kb7/9NoKCgjBnzhyv8XhmMXNzc2GxWJQxVlVVoampCTabzWu8s2bNQnR0NLZv3w5RFLF9+3ZYLBYlQPcr0+XMz97P3Ov+ehQIC3Znhcq/kLIz7Z1SABUb6d52sLbhiggDas+4M0HnLgC1Z6U+bxoHTBgLPLdAyiJtWwVMGS/t42cmSEHSzZobUC+2wS46YRZ0OOuyD7Gn5ITrInY6jwMAql3NuLvjXdjhRHpAHP7sPKxkoJTjXc4IrdOnemWZpmjcc8b29pzGwd4mAMC+njr8U+f/hRk6hAvqmTv5HORxAMD7PScRK4TAOERZ8KLYpWTK5GBwrGDy6dyvpb4XbAkJCaM8Ivqpujp3t83IlMpsH7whPfZh8jXOngbMEe5J3D5obGyEw+Hw+mPW17Zt25Q/7L7Mh1ELGuQ/UHJGaSQaGhq85hX5MreotrYWZrPZpwDmWpODD6vViuLiYrS2tmLhwoWYNWsWWltbUVxcjMbGRthsNp8Ct77kjFFOTg5ef/11OByOIecxXImRvD+yiooKfPzxx7jzzjuVdfn5+UhOTvaaiyEH70PxDEYFQYBerx+wnPyjFx2hPtm8r1qPuUzyUvG534czVjChTexGtCYYx10XMFYwwSZ2ox1OdIg9yjYyE7QDZnR8ZRO7veYV+TK36KxohwhRyWD9EFVUVKC1tbXf739UVBTOnDmjuo/D4UBTU9OQfXv+jgwVINlsNtVsPJEv/B8kWWKBOcukMtv/vg6c+gJ46Omhg5/9/0cKkuQJ3z6oqKjAsWPHMG/ePNVsw5kzZwZsA9QDov3798PhcCjlFKvVikWLFuHIkSODTvCTAza51l5WVqbMSTpx4gQsFgueffZZn88NkDIUNpsNq1atUh17bGysEjjk5+cjNjYWBw9KE931ej0mT56sjF+v1/t0TF8CT0DK0rW2tioBZ2lpKX72s58hIyNDydJUVFRg7969mDlz5oABjhxo5efnY+bMmf3a5dLoyZMnvcZUW1vbLysofxB6vncZGRk4duwYLl68OOC5jPT98XTgwAHEx8crmTN5rHJgnZmZ6dN7IGfQ/HqH3D8kuEtTCZcztvZOaQGAjOnSz2ADkJEsld98ndN0JRbeK2WI9n4m3Z02Ico9zsSbpeeHvwXOXQTGhgOZ/ed9+aLvXYi+mqIJx8zAGJgFHX6uicSXrvM44mrGEl2iss3z+hR85WoZtOxkF52oF9vwQOAkANI8I3lOkl10ohUOrNXPGNbk7/NiB7Y6q/FHfWq/u+vskLJVc7VTAEjZqie0SSjrrUOH6MQNQpASXD2vT8FkzQ0+HVM+j3iN73dGHjp0CMnJycpncGFhIWJjY1FUVITa2lrExsYqbfPnz4fFYhnxxagclHmW/jMzM9HV1fWTuVGErj3/zkkaPxX4zXrpbrbKy+WMd16Sgp9Ff3DvpzYnqbkeWJcF/OLeYX0FQHp6OqqqqpTyRG5urjKPJz09HfX19Upb3wm5eXl5OH/+vNJeU1ODiooKrF69GsnJyUrppbW11au8oqaiogJvvfUWZs6cCVEUERUVhfJy6WqwuLgY69evV9p8vfW0oqICCxYsQGhoaL8JwHl5edixY4dSIsrNzcWOHTuQl5enTI7Mzc1FeXk5vvjiC9hstkGP5XnMvXv3YvHixf3GOViKe//+/aqP5XlL8jg9J1MXFRXBbDajvLwcy5cvx1/+8hdlv763+cp9yeRypzzpvqysbMTv3Ujfn759HDlyBCEhIcr4bDab8m+rq6vLp/cgLy8PxcXFyuvvl69M+PrvQNZsqVT1SAZQ8pEUBLV3An96V5r7I5exLrVLk7+vlrix0nHeXQskTAD+bZNUWqs+BbxT7i6pPbdAel59SmrftAtIu31EX2Mgz4nxJaN5VrQjRNDh895zeChwMpI10tyZF/R3YafzOFY7PkGsEKKUxmKFEOUuuMG85DiEXwbEoDNkBZ7QJuGfO/9XaZP3bwl+0mty9lBe7z6Mrc5q1AU/5vUVAHbRice6PsKj2kR0hqxAS/CTqBfb8Hr3YSW4kidfN7raUd7z3ZDHkhV2V2P15YnpvkzcXrJkidfnc3Z2NtavX4/i4uJB20Zq6dKlXp+XoaGhWLp06Yj7IwIAkQuXK12sVqvY0NAglpWVjfpYuHDxXLKzs0WbzSYWFhYOua1J0IpFQfeJiRrLqI+bCxcuo7/wG7fJL+bPnw+z2ew1CZlotMlfa7Fjxw6f5pjZRSeqXGe8yl/Z2oQhMyZE9NM16pEalx/vkp+fLzocDtHhcIj5+fmjPh4uXPyxbAhKEztDVoidISvE9wwPiiZBO+pj4sKFy7VfhMsPiIiIiMgDy21EREREKhgkEREREalgkERERESkgkESERERkQoGSUREREQqGCQRERERqWCQRERERKSCQRIRERGRius6SIoUjPjStNDn/6xxuDYEpSFHl+TXPomIiOjaCBzxnrfcBTz2GqA3SM8bjgPrF0mPl78FxExxbyu32VuBpVuAs6eBna9492cKHXw/teMV5wI5bwDmG737sn0PrMsCmusHHH6kYMRHxrn4nWM/9vXUIVFjwWtBVjzc+T7scKIk6H5kBE4EAOztOY2srg9gF50jeaWu2IagNDyqTVSez+nchX09dVflWJGCEe8aHsBTXRWodjVflWMQERH9GIwsSLLEAv+cC2x5CvjmoHebKVT6WbIGqCwdft9q+83IBLLWqrc9M0v6OXcVMHYisPExnw4zVzsFW53VSrBR7WrGV64W/DzAggcCJ6FebIOhrQCAFKS8rP8llnWVD/98roBJ0KIk6H4AQET7plEL0oiIiK5HIwuSImKBIJOfhzKI22cDFSUjC7pURApGpAfE4d8cH+M9w4PICJyI464L+FP3/0NqwHjcqonAw53vK9sXdlfjtSArIgWjEkQBULI7npmdvlmflY79yjE/Ms7FFE24sv717sPKPn/rPYundb/AFE04jrsuYHbHTowVTAgT9FJ2SyVAStRYsMeYiRsFg1efnlmx82KH1/OxgglP6+4EAMzTTvEav+fYPzNlAYAylvNihz9eeiIioh+Nkc1J+uYg8Lc9wLI3gVcPSJmlvrLWAm98LS3PlbozTEPpu58lFjBHAE0nRjRUNWMFE466vsckTRjqxTZMt5fgSG8z2sRuhAg6XBIdsMMdlJwV7cp+gBQcvd9zEoa2Aszp3IUntEkwCVpsCEoDABjaCmBoK8BWZzUAKSP0R30qFnTugaGtABHtm5CsifKaA/W07heY3bEThrYCfNLbgLnaKRijMfYbiyxRY0Gx4X7c11EKQ1sB4tq34FFtIu4JjBvy/NMCx6MVjn7jX9ZVjrj2LfhrbxOm20tgaCvAbfYiBkhERHRdGvmcpJ2vSMuMTCD/Q+85SYD/ym1ykORHYzRGNInteCBwEt7vOYkxGiNa4YAd3T7tv7fnNA72NgEA9vXUYV9PHSIFI27VROCprop+298shCEtcLySuZGV9NQALunxVme1EozIZb3BJn2P0RhxoLdemTd0XuzAJ70NiNeE45xr8KDmhOsiXnIcAgCcc3UgTNDDBK1qMEZERHS9uvK72ypLgZUzpMe3pV9xd/102ABbCzBust+6jNeEo9HVjlDocc7VgfjLJS4AaBO7laBBJmeQ5IzSSJT3fIeI9k1KlsnQVjDk5OtvXRcwURPqNRYiIiK6NvzzFQBGs9+zPQp7K7D/bSljdctdfu3aLOhwkyYM6QFSiSo1YDx2O0/ikujA3MtZH5OgxVr9DPx3z7eDlp3scOKS6MDMwBgAUhZInt9zVrTj5wEWPKKdNqzxHextwmlXK57Xp/RrO+fqwKyAWKVkl6ixYFZALD7taQAAhAsGjBVMyvhvEIJ8OqZ8HmM0xmGNlYiI6KdmZOU2+W4zT3KZTJ57lLXWvY3nrfwAYM2SFgBwdEp3yX1XM/B+cvlt2Zvu4/Xtcxi+dV1AvCYcZb11+C/DP+IFx0Gs1k3Hrp4T+Mx1Bo91fYSPjHOxTp8KQCqFyZOsB2IXnVjjqMQeYybW6VOx1VmtTNo+L3ZgQecepQ3wbUK0XXQiq+sDlATdj86QFcp6eaL1SsfHygRreb1cfjvQW6+0/abrIzwU6Fsmzi468WfnYew2POTzOImIiH6KBADiaA/iWkvUWPC07k484djH2+qJiIhI1XX5jdunxEswCzql/GUStHhGNx0mgXN/iIiISHJdZpKAwb+3iIiIiOi6DZKIiIiIBnNdltuIiIiIhsIgiYiIiEgFgyQiIiIiFQySiIiIiFQwSCIiIiJSwSCJiIiISAWDJCIiIiIVDJKIiIiIVDBIIiIiIlLBIImIiIhIBYMkIiIiIhUMkoiIiIhUMEgiIiIiUsEgiYiIiEgFgyQiIiIiFQySiIiIiFRoNm/ePNpjICIiIvpB2bx5M4TOzi7x888/x6ZNG1FWVoaWlpbRHhcRERHRNRcREYH09HQ8+eRS3HHHHVKQNNqDIiIiIvqh4ZwkIiIiIhUMkoiIiIhU/H+YBFXsfwc1BAAAAABJRU5ErkJggg==)
In this example, we are declaring a variable called @OrderCount of type INT, and then executing the Stored Procedure with the parameter value of "John Doe" and the @OrderCount variable as the OUTPUT parameter. Finally, we are selecting the @OrderCount variable to retrieve the number of orders.
Stored Procedures are a powerful feature of SQL Server that can help you encapsulate complex SQL logic, improve security, and increase efficiency.
SQL store procedure in Hindi
SQL stored procedure ek reusable database program hota hai jo SQL statements ki set ko ek single logical unit mein combine karta hai. Stored procedures database server par store kiye jaate hai aur unhe client applications se call kiya ja sakta hai.
Stored procedures ke kai benefits hai, jaise ki:
-
Performance improvement: Stored procedures ki execution database server par hoti hai, jisse network traffic kam ho jaata hai aur query execution time bhi reduce ho jaati hai.
-
Code reusability: Stored procedures ko ek baar likhne ke baad baar baar use kiya ja sakta hai.
-
Security: Stored procedures ke through database access ko control kiya ja sakta hai, jisse unauthorized access aur SQL injection jaise attacks se bacha ja sakta hai.
Yahan ek example hai SQL stored procedure ka:
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkIAAADKCAYAAABJ2y+cAAAgAElEQVR4nO3df1RU550/8PdFdEB0sC5kAwwRU/AHQ03jaWmVNZIZ0mL63W42HLOty2ALbIxNzerZfDc0KdNk2J7onnRD41rXZLRfGU168EvaQ0+rp5mZajzoCVmTrHGIRvmqmQFMMDaM8mNEud8/bu6dGZhf/BzIfb/OeY7Mfe7z3Oc+F5wPz+cZFQCIICIiIlKhhHgPgIiIiCheGAgRERGRajEQIiIiItViIERERESqxUCIiIiIVIuBEBEREakWAyEiIiJSLQZCREREpFoMhIiIiEi1GAgRERGRajEQIiIiItViIERERESqxUCIiIiIVIuBEBEREakWAyEiIiJSLQZCREREpFoMhIiIiEi1GAgRERGRajEQIiIiItViIEQURyaTCd3d3bBYLJN6HavVClEUYbValWMGgwEejweiKMLn8036GIiIpqPEMbcsKgPKn/O/bmsBfvNvwJMHAO1f+Y8f+BnQ0iR9vWUPkF/kr/N+CrxQDnS7g/t0HgAObQ/dJrDf9+zA1n2Abqn/uOccUF8J9PaEH/vy1cCmXwKa5JHjXF8DGMrD9xc4nuHjH96v3ParJcFzJV/vw9aR8yXfe3o2sOVl4LU64IMT/vkp3iD1WfnvwfPS1gLs3BR6zoaPc4KZTCb8x3/8B3bv3g2z2Twp14iV1WpFaWkpKioq4HQ64zqWiTbR8+x0OqHT6ZR+iYjUaGyB0Poa6U35pUf9b9KA9Obt6wNe+ol0vKgM+O4T0hu+/CYcGOQMl18E/GE3sOybQEqqFHzIb+7LVwPfrwV2PurvKyVV+jMw2IqV96q/r6Iy6Z6udUl1clCRkioFWg9ulsa8vgbQpgFPFkljW18DPFofHOyEG0uoAG34fKVnS4ERABw9GP0eAoOmJw9I9yFfO9I8k+pUV1ejuro63sMgIpp2Rp8aS0kFlnxdepMNDIJCudYFCAKQlh293/RsICkFeKtZen2XftRDG7MPW6WAZGFG8PHeHilgunOxNL6vrAVe/4U/mDl6ENDMlca68ltS8DHagCxQtxtofkma3+T5sbfr80rjzMwb+7UBWCwW+Hw+iKKoFJfLFbJOTrG4XC40NDQgLS0NtbW1EEURXq8XJpMp6vUCUzOiKMLj8cBgMMButyvXBTDitcvlUtrIKR2TyQSv14uqqipkZWXB4XAEjT/ctSwWC9rb29He3g6fz4fm5mb4fD6lfvj1Ao9brVa4XK6g+sDUUzjyWEVRRENDA7Rabcg6URRht9tjmufAMQSOYzzpr1DzTET0RTP6QGiuVnrzl1dPIim4D+jpBj7yv4nBUA7sPiOVHcekAAMAlhQCVy5KwcBll9Q2VuXP+ft8psm/UhSrJYXSnx+2Bh9PzwZ0y4B3/uQP5q4GpJf6vFIAdefd0kpR5/nw19AtBV5o8Y+zqCz0ede6pPlNnhf7+O/SA6npwJk3/cfCzXMYJpMJW7duhc1mgyAI2Lt3Lzo6OrBlyxaYTCZUVlaiuroagiCgoqICpaWlMJlM0Ov1qKiowNWrV1FXVwdBEKDVamGz2SJez2AwoKGhAT09PRAEAYIgQKfTRU1nWSwWJCUlwWg0QhAEaDQamM1m2Gw2aLVaZdxyvV6vV6519uxZ5Vo9PT3YuXMnAECn0+HixYu4cOECiouLYbPZoNFokJWVBbvdjq6uLqXd2bNn8fTTTyvjyc/Px8mTJ5U5Ky0tVQKlcPO8a9cuNDY2KnPp9XqVOXn22WdRX18PQRBgNBqxePFiWCyWqPOs1+uVMdbV1eH++++HwWBQ0l+B14lFuHkmIvqiGX1qLO3zlZtwNHOBJ16Wvg6VDgqVsklJlfa+HH1Ven3mTeA7m/3psWjGkhrTpgGWw9LXw/fQ5BdJAURg38tXh+9Lkyz1F0m41Nh4GMql4usH9vxz8ArdBKTGtFotsrKysHbtWmRlZaGhoQENDQ0AgJs3byIvb+wrUMXFxdBoNNi+fXRjPH/+PNLT03H48GHs2LEjpjfnrKwsAMD+/fuVYydPnkRpaSlycnLg9Xqxf/9+1NTUoLW1FZ2dnQCkIGfZsmXIysqCKIpK27a2NuXrjo4OvPqq9H0bS+pp7dq18Hq9SptAxcXF0Ol0qK2tRW1trXI8MzMzar92ux1Go1F5ff36deW+x2Is80xENBONfkXoqhsQxZFpJJmvT9o7ZF4nBQeV/x69z7v0QPpd/pWdJ16WVmImMz3mvSqNcXMB8NTa4I3EbS3ScecBaR/Q8tX+laDANJ+8OvbxpQlJTQGQ5tXXB/TfCD9uOZhyHpDG2f4O8IPnxxVY2Ww2uN1uVFVVQRRFmEwm1NfXKysObW1tyopDPFcI5JWfdevWobKyMuZ01Fj5fD5lBUYuev3kfV96PB5lFUYu0QIsi8WCwsJCZZx1dXXw+XzjGsdUzzMRUbyMPhDqdgP/fVjaBB3pjVc+T7cs+ht0wX3Sm/nmAn9paRpdemwyHD0oBSUF90n30/0RULLRX/+9n0rH3n1DWs0qKou8chTN8tVS4HX0VeDTDv+1Af+q2ZWLI9vZ90sBmZziG4NIqZDOzk7k5uaGfSPs6OiAz+eLaeVCdvToUfh8PmzcuDFkfWpqqrKHZ82aNSPq5ZSPw+FATk6Ocryzs1NJawWOD4ByLYPBgNLSUpw9exaXLl0KO8a2tjYMDAygsrIyYrprNDo7O6HValFcXAyDwYDnn39e2SMkr8IEpt4ChZtn+fX581JqtqysDBqNZkLGG26eiYi+SMQxlfU1Inaf8Zcte0SkZ4uwHBaxfLV0TkqqiGeapHMB6ZzANjuOibgrXzqnqCy4/6IyqT49W3q9fLXUt/w6sP/APp9pko5HGnuovgLva8ue0OMYfr3h1yoqCz2W4cd3n5GOpWdLfcvH6t/2zx0wsj5wXFv2+OdVHrd8vVDzHOpehxWXyyUG8vl8osViEQGIVqs1qM7j8YgGg0FpG1jv9XpFk8kU9Xomk0n0er0j+gw87vV6xebmZtHlcsU0juH3Ibcbfi35uMViEbu7u0WTySS6XC7RbrcHHTMYDKLH4wm6ptVqVcYS6vrRit1uV/p67bXXxPb2dmWeLRaL6PP5ws5lqHkePsZTp06JHo9HNJlMI+478LlGqotlnllYWFi+ICXuA2CZBiXwzV8+5nK5lICBhYWFhYXli1j4L0sTACm9EphOMRgMSE1NRVdXDJ8OJCIimsHiHo2xTI8yPDU2ntWg4SmeQLGmzmZiCZVuGp52ivcYWVhYWFj8Rfj8CyIiIiLVYWqMiIiIVIuBEBEREakWAyEiIiJSLQZCREREpFoMhIiIiEi1GAgRERGRajEQIiIiItViIERERESqxUCIiIiIVGvaBEIvJRnRP38b+udvw+Nz7o33cKYFi8UCn88Hu90e9hyTyYTu7m5YLJYpHBkREdEXQ2K8BwBIQRAAJF9/ESnCbBxI+g4+TLyGN25dnpTrPZC4CD+afS/KB/6AXnFwUq4x3axISMcf55bhr4Rk5diRWxdRPvAH/GB2AV7QFOO7/a/jjVuXlWfw6q02PDNnFZYmLAzq69zQNXyr7xA+Efum+jaIiIgmVNwDoRUJ6UiFBj/yvQEA6BUH8avBd/G3ibmTFgjNFGazGWazeUL6Oj3UDd2N/8KKhHT8MsmAf+j/fVAg8+HQX1CeqMeJ253Ksc9EH77aux8A8Pice7E0YSGeGHBMyHiIiIimg7inxqrnrMCBWy78YHaBkhq7U5gHAEgRZmNFQjo88x4bkTZ7fM69ykpSqNeBqTbPvMewIiEddwhz8V7KRjQnP4zSxMW4Ou/H6J+/TWmXIszGb5MfUtr9NvkhZQz7kx7E/qQH4Zn3GEyz9fDMe0ypH3694cdNs/V4L2Uj+udvw3spG3GHMDfqvLhcLoiiCFEUYbVag+pMJhO8Xi9EUURDQwO0Wu04noDk2G03POJ1fFlYMO6+iIiIZoq4BkJysHBlqBclsxYhv3cfGgfP4Yp4AwCgT0jDH+eW4YcDh5F8/UUkX38Ru26+G7VfeZUp7cZ/Ivn6i9Dd+C+cHurGJ2Ifvtq7H9/tfx1Hbl1U6p8YcCjpIPvty8q13OJ1PK+5DwBgTLwLrUNdeP3WefzLnK/hhwOHsUDQIAWz8fice3Fu6JrSzn77Mn4wu0AZz7/M+Rq+1XcIyddfxJu3PVg/e2nUe9Dr9TAajejo6Ag6bjKZsGvXLjQ2NkIQBFRUVMDr9cY855Ecvf0RquesmJC+iIiIZoL4BkKQAqEvJ3wJbvE6esVBaIU5uDLUCwAompWF12+dH3WK7IrYi3tmpeNcShVWJKSPaiyHBs8px35/6wKyhflIEhJxfugvSt0rg6fx8ZCUVporJKJk1iK8oClWVoRe0BQH7at5ZfC0koZ6YsARUzAXztq1a+H1evHqq6+OuY9wTtzuRCo0+EqMc0ZERDTTxXWP0J1CCq6LN5GVMA/nhq7hTiEFXvEmbmB8G5jllR95lac0cbGyEXgyeMWb+EbvAZwe6p6U/qdKrziIA7dcWDsrO95DISIimhJx3yMkW5qwEGsSddAKc3BPwh04N3QNjluXsXZWdthVnWxhvrKH5ydzvjGivlccxN/3/w5P+o5iScAKzcdDfUpaSzn38+BLTlulCLPxo9n3wn77MgbEW2HH3SfeQg98eE5TpKT6JlNnZye0Wi2Ki4thMBjw/PPPT8geIdn/3O5GaWIO7k7gXiEiIvrii2sgdEXsxXxhDk7d/hgPJ+ahMCEDAPCsZjUODZ7D6aFuPOn7M95KKR+xWfrQ4DksTkjF1Xk/RkPyg/iJ77jS7wOJi5Tz++dvQ8msRfg/g2eU+tND3Xh/6Couz9ukbJbuFQexaeBP+KfZK9A/fxuuzvsx3OL1mNJYP/G9CQDK5uv++dvwQOKiMc+LwWCAx+OBw+FAVlYWqqqqlE3TZrMZra2tqK2thcPhwPHjx+HxeKL2KW86fyulHN+clYnL8zYFbeqWfSL24f/e+hBLEr405vETERHNFAIAMV4XTxFm41eaB/CLm2/P+LQSERERzTxxXRHqFQfROtQVlFYyzdbHvMGZiIiIaDzivkdo18134RavK2mlhxPz0C5+Fu9hTarAfwdoePH5fPzvMoiIiKZIXFNjRERERPEU9xUhIiIionhhIERERESqxUCIiIiIVIuBEBEREakWAyEiIiJSLQZCREREpFoMhIiIiEi1GAgRERGRajEQIiIiItUaWyBUVAbsPgOsrwl9XC5b9kzAEImIiIgmR+KYWuUXAX/YDSz7JpCSCvT2AMtXA9+uBszrgG73BA+TiIiIaOKNfkUoPRtISgHeapZe36WX/lyYAWjmTuDQiIiIiCbX6AOhJYXAlYvSqs9lF1Bwn3S8pQnwnAUsh4FnmqSVIiIiIqJpbHSBUEoqULwB6DwvvT7zJrBI7w96dm4CNhcAH74NvNDCPUJEREQ0rQkAxJjPXr4a2PRLQJPsP+brB/b8M/DBieBz07OBLS8Dr9WNrCMiIiKaBka3WbrgPqD9HWnlR7a+Rjo+PNhJ+3wvEREREdE0FXsglJIKLPk6cPTV4OOd54HvPgEkzwNWPeQ/Hm6liIiIiGiaGF1qjIiIiOgLhP+yNBEREakWAyEiIiJSLQZCREREpFoMhIiIiEi1GAgRERGRajEQIiIiItViIERERESqxUCIiIiIVIuBEBEREakWAyEiIiJSLQZCREREpFoMhIiIiEi1GAgRERGRaiWO6uz0bODJA4D2r/zHnAeAQ9uBlFRg6z5At9Rf5zkH1FcCvT0j6339wJ5/lr7e9EtAkxzc7uWtwKP1gDYNeKEc6HYDy1cD368Fdj4qvSYiIiIah9EFQgDg6wNe+gnwwQl/YHL0INDnleoP/AxoaQpuIwdQ/30Y+HnZyD63fn1kkJOSKtXd7AeK/1EKtoiIiIgm0PhTY96r/iAonOJ/lM774+7R9//W74E7F/sDIyIiIqIJMvoVIc1c4ImXpa/l9Jac+gKA8uekAvhTY3cuBj58WzpvfQ1gKJfqQ60eDfeXK8DiFcBXS4BrXaMeLhEREVE440+N/XA78Osa4COXVB8tuDm0XVoZ2rov9mva9wPf2SztRyIiIiKaIONLjX3kAnq6gYUZkc+7clFaFRqrD05I18nMHXsfRERERMOMLxC6Sw+kpkdPWZ15E/jySqAoxEbpWLW1APf9w9jbExEREQ0zMXuEPjgReY/QByek8zb90l/n65cCqOWrgz8+bzns//h8oPfsQPEG6eP0RERERBNAACDGexBERERE8cB/WZqIiIhUi4EQERERqRYDISIiIlItBkJERESkWgyEiIiISLUYCBEREZFqMRAiIiIi1WIgRERERKrFQIiIiIhUi4EQERERqRYDISIiIlItBkJERESkWgyEiGhUDAYDPB4PPB4PDAaDctxqtUIURYiiCJfLFccRqovL5YLdbh91HRFJpkcgVFQG7D7jL1v2SMeXrwbq3w6uW18j1aVnA5bD0jnDRWoXqv6ZJuDeB0a2ketSUid/DoaR32ysVuuUX5ui4/MZqbq6GoIgwOFwxHsoEZlMJnR3d8NiscR7KEQ0DSTGewBYvhr4djVgXgd0u0fWe68COx8NXRdJuHZFZUD5c8CBnwEtTcF1774h/bllD3DlInBo++iuSaQCTqcTOp0u3sMgIpoQ8V8RWpgBaOZO3fVWfgtwHhgZBI1TYFpAFEVYrdYRv3kOf22xWODz+UakE+x2OxwOB7KyslBVVQVRFOHz+cK2k5e+XS4XWlpa4PP54HK54HK5lLGEaicfNxgMaG9vR3Nzs1I/PO0Rit1ux6lTp+D1eiGKIrxeL0wmk3Kv8vHAOpPJBI/Hg1OnTkEURTQ3N8Pr9Qa1lccd6zhiEdhn4Fgm4/mE+l4Yz/OxWCxob29HS0vLiGcejd1uH/UzGD6OwGcQj/RXqGdnsVjQ3d2tfM8Mfz38GQT+jDQ0NCAtLQ21tbUjvm/D/RxH+54NNc/yuMby7CI9g+Fzkp+fH3a+AutcLpcy9mg/r4FjDPdzEGmeiWaS+AdCLU2A56yU5gqVhtKmSXWhUlyRhGqXkiod7zw/obcg/2VZV1cHQRAgCAKqq6ujtisrK4PNZlPa6PV6AEBJSQmMRiM6Ojqwd+9eCIIAjUYDs9kMi8WCrVu3YseOHRAEARUVFSgsLFTeNL/yla/AZrMhNzcXXV1daGtrQ05ODkwmEyorK5X0RUVFBUpLS5W/CDUaDVauXIl169bBaDQCADZs2BD1HlauXInGxkYIggC3242NGzcCAGw2G7RarXJvra2tSp1Wq0VSUhIcDge+/e1vo7GxET6fD3l5ebDb7ejq6lLanT17Fk8//fToH0oAl8uF1NRUGI1GCIIArVYLm80Wtd1Yno/VasUjjzyCiooKCIKAuro6PPLII0qQNNbno9Pp0N/fr/R5zz33KHXhWK1WZGRkKONvbGxETY308xPpGZjNZmg0GqVdT0+P8r0w1emvsTw7g8GA+++/P+jnsaSkBACg1+tRUVGBq1evKvVyn+GeXVlZWcT5ijTPwNieXaRnIAcicl1bW1vQfIWrA4Di4mI8/vjjQT+vBoMBzz77LOrr6yEIAoxGIxYvXqx8z4b7OYg0z0QzSfwDIQDYuQnYXAB8+DbwQot/jxAgpbjM66T6zQWxp6tCtZurlQKhCbZq1SocP34cZrN5VO26urpQVVU1qt+sMzMz4Xa7lWvZbDa43W7k5OQAAFpbW9HZ2Qmv14v9+/cr7dauXYusrCw0NDRAFEU0NDQgPT0deXl5yjlHjhyB0+lUUh+xBHNtbW3KeV1dXcjIyADg30Mj/6ZoNBqVOp/Ph6YmaUXuwoULOHbsGAAgJycHy5Ytg9FoDNluLEwmE+644w7s27cPTqdzVG3H8nxycnLQ2tqqvFkfPXoUXq8XmZmZAMb+fALPN5vNSE9PjxoQrFq1Cvn5+cpcVlVVITU1Ffn5+WGfATBydSA/P1/5/ppKY312TqcTAwMDqK2tHdUKRbhnt2DBgojzFW6e5RWcsTy7cM9AnhN5LMPbhKuTBd6fXq9HSUkJiouLodPplBUyh8OBu+++W/meDfdzMNZ5JppupkcgJDu0XQpe0u8KvQl6vPq8UoCUmRf93ClQUlICQRBw8uTJCU0DhdPW1qb85ha4ijEZ5FUc+Tf5WFcQfD5f0G+Ygb+BTrUvwvORV6zkotPpRqwSDFdTUwO32x12VWEm0Ov1EAQBAKYkjRdqnkcbeAea6mfg8XiUn9Xhq9qRfg6mep6JJsP0CoQAIC0bSEqZnL57e4Cjr0obpicw0Dp58iQKCwtDLndrNBrlN6uamhpotdoR51RXV6OiogIAkJWVBUD6baunp2fEb+KdnZ3Izs4O2seSnZ2NEydORBxjZ2cncnNzp+xTThkZGejp6YHT6YTJZEJhYWHUNpcuXcLAwAAqKyvDBhzyb8qxBiU2mw2ffPIJysrKQtZP9PO5dOlS0PfChg0boNVqg1YQQpmM59PV1YVHHnkkahomUE5ODlJTU9HV1QVA+v7Kzc2dkPHI+0liXT2I5dnl5eXBYDCgsrISGo1mxDklJSWoq6tDUlKS8v3S0dEBn8+nPHdZuGd39uzZiOMcyzxHYjAYwj4DeeyrV0t/f9ntdmUfUKS6SM6fP4/09PSoKehQPweyUPNMNFPEPxBaXxP8cfVNvwR+XQN88Pkbe6Q9Qpq5wBMvh/6oe7h2LU3SylO4dmNQXV2N1tZWJa0hb7K02WxobW1VNtR+9tln8Hg8AEamjhoaGnDkyJGgJfOmpiasWbMmaDOu2WxGY2OjsoxdW1uLxsbGqCsHZrMZNptNGctkr3A0NTUhNzdXmYv3338/pnZbtmwBADgcjhGbhgHpL3uv1wutVjviL+NIfaampo7YzDoZz2f494LJZEJ9fX3UVMhkPJ+SkhK43e6g78toQcilS5dw5MgRJT25detWnDlzRqmXNwUbjUYlHRS4iTxcHSAFezdv3hxVqjPcszObzXC73aitrYXD4cA777wDr9cLYGRa6amnnsLBgweVFRqn04kjR44ocy33Ge7ZtbS0TPg8RyKPL9QzcDqd2Ldvn/J9l5GRoay2RqqLxGazob6+XmkXOCeRfg6izTPRTCKysMykYrfbRY/HIxoMhriPhSX2YjAYRI/HI9rt9riPhYWFhSWgxH0ALCwxFYvFIvp8PgZBM7DY7XZRFEUGQSwsLNOxxH0ALNO0yG9eobhcrriPT+2Fz2fmFpfLFfbZMVhkYZnaInz+BREREZHqxH+zNBEREVGcMBAiIiIi1WIgRERERKrFQIiIiIhUi4EQERERqRYDISIiIlItBkJERESkWgyEiIiISLUYCBEREZFqJcZ7AEhJBbbuA3RL/cc854D6SuDBzYChfOTx3h7p9ZY9QH6R9LX3U+CFcqDPK/XnvQrs3OQ/T7dMqu92T819fc5gMCj/Y3N1dfWUXpuIiIgimz4rQgd+BmwukMrPy/zBTluLdOzJzwOeBzdLf66vAbRp0vHNBcB/HwYerQfmaqUgCADSs6UC+I8RERERfW76BELR9PZIwcydi6Xg5itrgdd/4Q+Yjh4ENHOBL6+UAqSLp4ElhVK5eDrmy1itVoiiqBSr1QoAcLlcsNvtynmBrw0GAzwej9LG6/XCZDLBbrfD4XAgKysLVVVVEEURPp8PFosFAGCxWODz+ZR2cn92ux2nTp2C1+uFx+NBS0tLUL3JZILX6x3RzmAwoL29Hc3NzUq/Ho8HBoMh5L0F3g8REZEaTZ9AqPw5YPcZqWzZM7I+PVtKb73zJyDt81WeqwFprj4v4OsDFtwhvb7wDnD3V6Xy/lGpTm4XhtVqhclkQl1dHQRBgCAIMaWzNmzYgJ6eHqWNVquFzWZDSUkJjEYjOjo6sHfvXgiCAI1GA7PZDIvFgq1bt2LHjh0QBAEVFRUoLCxUAq+CggI0NjZCq9ViwYIFcDgcyMjIgMFgwLPPPov6+noIggCj0YjFixcrwZVGo8HKlSuxbt06GI1GZXwGgwH3339/0L2VlJREvTciIqIvsukTCAWmxuS9PYC0B2j3GcByGGh+CWhpiq2/Tz3AQK9UrnpiarJq1SocP34cZrN5VEPv7OxEbm6ushIUi8zMTLjdbuVaNpsNbrcbOTk5AIALFy7g2LFj8Pl8aGry33NxcTF0Oh1qa2shiiIcDgfuvvtuZGZmKuccOXIETqcTTqcTOp0O1dXVcDqdGBgYQG1tLVeCiIiIPjd9AqFw5D1CzgPSvqDlq/0rQYErPHO1UmpMFKXVnz4vcGi7VCaZ2WyGRqPB448/jl27dgWlvyaDx+OB0WhUVnZiXbnS6/UQBAEAIIoiXC7XpI2RiIhoJpj+gZDs6EEpwCm4T/rkV/dHQMlGf/33fiod+6htzJc4efIkCgsLw67qZGRkAJBSaPn5+SPqbTYbtFotLly4oKzQOJ1O9PT0KCs9ss7OTmRnZwftF8rOzsaJEycijvH8+fNIT0/H008/Per7k5WUlKCurg5JSUnK/iEiIiI1mjmBULdbSo19bZ20X2jfv0qbouV9Rdo06Vg4mrnAwoyIl6iurkZraysaGhpGbJZuampCbm4uRFFEaWlpUMBit9uDNiHLfcmampqwZs2aoM3SZrMZjY2NSoqrtrYWjY2NUdNyNpsN9fX1Sn+Bm7MjGb7B+qmnnsLBgwfhdDojtiMiIvoiEwCI8R4EERERUTzMnBUhIiIiognGQIiIiIhUi4EQERERqRYDISIiIlItBkJERESkWgyEiIiISLUYCBEREZFqMRAiIiIi1WIgRERERKrFQIiIiIhUi4EQERERqRYDISIiIlItBkIUE5fLFfV/ubfb7XC5XJM6jhUJ6fDMewz987fhvZSNuEOYO6nXmymmy/MhIppp4hsIpaQCzzQBRWXBx4vKgK17R9YtXw1YDgPp2QD9XL8AAAlfSURBVNLX9W8Du8/4y/oa6bz1NcHHn2mSriX3Ea7dFDMYDPB4PLBarXG5/kyzIiEdtuTv4MG+JiRffxH/23cUe5K+hRRh9qRcL0WYjd8mP4QHEhdNSv9ERBR/ifEewLh4rwI7HwW63SPr2lqAnZukAGjrPuDBzcCh7dHbUUh6vT7eQ0D1nBV40vdnnB7qBgCcuN2J8kQ9viwswGmxO86ji6/p8HyIiGai+K4I9fZIQUkon3w0sde4c/G4u7JarRBFUSnySo7L5YLdblfOC3xtsVjg8/mUNnJqwm63w+FwICsrC1VVVRBFET6fDxaLJWQ7uT+73Y5Tp07B6/XC4/GgpaUlqH54O3mMBoMB7e3taG5uVuo9Hg8MBkPEew7sL9T5drtduZbRaBzvFIe1IiEdqdDgwtBneC9lI/rnb8OBpO+gbehT/HWClB57IHER+udvU8oDiYtwhzAXf577D1iRkA4AI14Hptr652/DS0nSPTw+515cnfdjlCYuRnPyw+ifvw2eeY+Fbff4nHsBAC8lGfHUnG/AM+8xvJRkxEtJRmUsodrJx1OE2dif9CBMs/VK/W+TH4q62jVdng8R0Uw1PfYIZeYFp70y8/x15c/5U1hPvAxoAvaEaNOkNpFSXOnZgG4Z8M6fRtduGKvVCpPJhLq6OgiCAEEQUF1dHbVdWVkZbDab0kb+zb2kpARGoxEdHR3Yu3cvBEGARqOB2WyGxWLB1q1bsWPHDgiCgIqKChQWFipBTUFBARobG6HVarFgwQI4HA5kZGTAZDKhsrIS1dXVSrvS0lJl34hGo8HKlSuxbt065U1xw4YNEcdvNpuh0Wiwd+/eEXV2ux3Lli2D0WiEIAhwOBxR5wOQAsXAgDKWoOyvE+aidagLDybejVcGT+O7/a/DLV7HDdwEIAVBv05ah2/0HkDy9ReRfP1FvHHrctSxVM9ZgR8OHFbaPDEg3cOum+8i7cZ/4siti/hu/+tIvv4idDf+C6eHukek6Bbd2IN/mr1CCWq+P3sZfjhwGA8n5uHc0DW8MngaSxIW4g5hLp7TFGFlb4PS7kez71X2OWmFOXg4MQ9Le/ci7cZ/AgBWz8qMOP7JeD5ERGoS/9TYlYvSn8nzpZWbJYXB9Qd+BrQ0SV8vXw18v9ZfFynFlV8kBTnD+4jWLoxVq1bh+PHjMJvNMbcBgK6uLlRVVWHVqlUxpy8yMzPhdruVa9lsNtTU1CAnJwcAcOHCBRw7dgx/93d/h6amJqxevRoAsHbtWmRlZaGhoQENDQ0AgJs3byIvLw8dHR0AgCNHjsDpdAIAdDrdqO4lkMFgwLJly4L6i9VY0jhLEhaiY+gG/j4xD7+4+TbWJOpwbuiaUv+3ibl4/uZbStosVueGrqE5+WG8MnhaCYKi+euEuTh2261c6xOxD2/e9mBJwkIAwCuDp/HxUB/OD/0FhwbP4aeaVQCAe2alozRxMS7P26T09anYjzuFFLSLnwEAfjX4LnrFQQDA3/f/blT3Emg8z4eISE2mx4oQAOj/Bjj5OymAAYCu9vH119YCbC4AnAekFZ/lq8c/xjEoKSmBIAg4efJkzOmo8Whra1NWnwJXmaaTsawIZQrz0Iub0ApzcEXsxdKEhfgwIBAaq10330Xy9Rfx+1sXYk5Hjccrg6eV1afAVSYiIoqP+AdCneeBJV+Xvn7PDiSl+F9PhKMHAV8fUHDfuLo5efIkCgsLw348OSMjA4CUQsvPzx9RX11djYqKCgBAVlYWAMDpdKKnp0dZ6ZF1dnYiOzs7aL9QdnY2Tpw4EXGMnZ2dyM3NnZJPocljX7VKWu2wWq0x70HR6/VBwZogCNDpdDGtXCwQNLhnVjrum6VDCuZgacJC/M/tbvz+1gX80+wVIT9O/yUhSdlH9FPNKuQlfGnEOW/cuoxFN/YAAFIgBUK94iDc4nVlpUf28VAf1s7KDtovtHZWNo7f8kQc+8dDfXg4MW9KPoU2nudDRKQm8Q+EAEC3FPh/70kbm69cBNLvAj77OHq7WPb6dLuB5peAr62T9gvF2m6Y6upqtLa2oqGhYcRG5KamJuTm5kIURZSWlioBi/zxePn8hoYGHDlyBDabTem3qakJa9asCdosbTab0djYiNraWoiiiNraWjQ2NkZd2TGbzbDZbMrm64lYgZI3iFdVVSErKwsOh0Ppc/v27cjOzlbu+ze/+c2YrxNNp3gDAPD+0FX8OmkdXhs8i9eS/xfODV3DJ2If3rh1Ga8MnsbleZuCNiJ/IvbhlcHTyobnjqEbcNySNuLLH4+Xz788bxN+NfguPhH7/Pd/8zR+MucbQZulTw9140nfn/FWSjn652/DWynlQZ9mC+f0UDd+OHBYGctErEBNl+dDRDRTCQDEeA+CKJoHEhfhbxNzY97HQ0REFIvpsSJEFMX/3O7GfbN0SlrpDmEu/nVOYZRWREREkTEQUrnh/+5QYIn2XzZMpU/EPlT0/xG/TlqnpLHeHYohfTrDzZTnQ0Q0UzE1RkRERKrFFSEiIiJSLQZCREREpFoMhIiIiEi1GAgRERGRajEQIiIiItViIERERESqxUCIiIiIVIuBEBEREakWAyEiIiJSrcRRt9iyB8gv8r/2fgq8UA4U/yNgKAcO/AxoaQJSUoGt+4CjrwKZeVLd8Dbd7gm4BSIiIqKxGX0gBADOA8Ch7SOPX78GrHoIeM8+sq6tBdi5Sfp6fQ3w5AEGQ0RERBRXE5sac38A9HQDd+kjn/fH3YD3KrCE/3s4ERERxc/YAiFDObD7jFR2HAPSs/11bS1AycbI7Xt7pEAoM29MlyciIiKaCBObGgOktNiqh4Cl3xzHsIiIiIgm38R/aqy3Bzj5O6Dgb8Kfk5IKaNOAzvMTfnkiIiKiWE3Ox+c/bAVyvwakpoeur/x36c9Qm6qJiIiIpsjYUmOGcv/H4eWPwgfqdgPvHwv+yHx+kbSnCJD2Ef28bEyXJiIiIpooAgAx3oMgIiIiigf+y9JERESkWgyEiIiISLUYCBEREZFqMRAiIiIi1WIgRERERKrFQIiIiIhUi4EQERERqRYDISIiIlItBkJERESkWgyEiIiISLUYCBEREZFqMRAiIiIi1WIgRERERKrFQIiIiIhUi4EQERERqRYDISIiIlItBkJERESkWgyEiIiISLUYCBEREZFqMRAiIiIi1Ur43ve+h7S0tHiPg4iIiGjK/X/MjnJx5dERyAAAAABJRU5ErkJggg==)
Iss stored procedure mein get_customer_details naam ka ek stored procedure banaya gaya hai jiske liye @customer_id parameter ka use kiya jaata hai. Iss stored procedure mein customers table se customer ki details select ki jaati hai jiska customer_id parameter ke through value pass kiya jaata hai.
Iss stored procedure ko call karne ke liye, neeche diya gaya code ka use kiya ja sakta hai:
Iss code se get_customer_details stored procedure ko customer_id ke value ke saath call kiya ja sakta hai.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com