The Stored procedure is compiled t-sql program stored as object under the database. It will use the cache execution plan for all the subsequent requests. It can accept parameters. Advantages of the stored procedure It will improve the execution. It will compile once and be stored as an object under the database. The same execution plan will be used for all the subsequent execution. It will reduce the network traffic. It will have only a few bytes of parameters. But the inline query will make more traffic. It will be stored in the SQL Server database and any number of applications which return in the multiple languages/application can utilizes the same stored procedure. The permission can be set to the stored procedure. The stored procedure can be changed the logics without redeploying the application in circumstances. The application developers can work in the front end and the SQL developers they can write the SQL Server. for example refer http://www.c-sharpcorner.com/UploadFile/shashikantray/understanding-database-stored-procedures/ http://www.c-sharpcorner.com/UploadFile/skumaar_mca/good-practices-to-write-the-stored-procedures-in-sql-server/ http://www.c-sharpcorner.com/UploadFile/shashikantray/understanding-database-stored-procedures/ Thanks

Answer

wat is stored procedures in sql server?how to use?

nallamma

12y

1.7k

with Examples???????

Answers (1)

Next Recommended Forum

Can a trigger create a table ?????

@@Rowcount in SQL

Forum Statistics

Please welcome our newest member Mohd Talha.
3,089,258 users have contributed to 147,411 threads and 483,541
In the past 24 hours, we have 1 new threads, 1 new posts, and 51 new users.
In last week, the most popular thread is 'what is Pandas how to use?'.

Upcoming Events

View all

Live Discussion on Startups and Career Growth
From Prompt to Product: Coding in the Age of Gen AI
Auto-Archive Client Documents for Compliance: Automate Your Business Processes - Ep.6