SQL Server Stored Procedures

Email Alerts

Register now to receive SearchSQLServer.com-related news, tips and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Microsoft previews new SQL Server in-memory database features

    Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server. 

  • Saying yes, no or maybe to stored procedures

    The world of software somewhat resembles a pendulum. Styles of development swing in and out of favor. Take stored procedures, which work to some extent and may sometimes be the shortest way to a successful project. 

  • SQL Server freebie: PromptSQL for word completion

    This add-on application, available for a 30-day free trial, provides auto-complete functionality as you type for programs used to create SQL statements. 

  • Why use stored procedures?

    Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be: "Why tolerate the added development overhead?" After seeing the advantages, you may change your mind. 

  • library

    In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, and physical storage units such as tape cartridges. 

  • trigger

    A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm. 

About SQL Server Stored Procedures

Stored procedures are intended to make SQL Server development easier. Why write the same query over and over again, when you can just save it in the database. Writing stored procedures in T-SQL and CLR are covered in this topic's section, from querying and debugging to working with triggers. A stored procedure simplifies database development because it allows for more modular programming. You can create discrete pieces of functionality with stored procedures. Stored procedures have the parsing and execution plan built in when they are created so they execute faster than dynamic SQL.