{"id":1071,"date":"2015-01-14T17:36:46","date_gmt":"2015-01-14T17:36:46","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=1071"},"modified":"2024-01-05T20:32:37","modified_gmt":"2024-01-05T20:32:37","slug":"jan-2015-introduction-to-sql-stored-procedures-matt-batalon","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=1071","title":{"rendered":"Jan-2015- Introduction to SQL Stored Procedures ~ Matt Batalon"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/matt-batalon.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-710\" title=\"matt-batalon\" alt=\"\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2012\/03\/matt-batalon-150x150.jpg\" width=\"150\" height=\"150\" \/><\/a><\/p>\n<p><span style=\"color: #800000;\">Presenter:<\/span> Matt Batalon<\/p>\n<p><span style=\"color: #800000;\">Topic:<\/span> Introduction to SQL Stored Procedures<\/p>\n<p>SQL Stored Procedures have been part of SQL Server since the early days. They are fundamental part of almost any SQL Server database.  In this introductory  presentation we will cover the benefits of using stored procedures in your database development projects, and also look as some drawbacks stored procedures might have. We will also cover the following topics to get you equipped to start writing, modifying and debugging stored procedures of your own.<\/p>\n<p>We&#8217;ll cover:<\/p>\n<p>1. Creating Stored Procedures<br \/>\n2. Modifying Stored Procedures<br \/>\n3. Creating Stored Procedures with parameters<br \/>\n4. Creating Stored Procedures with optional parameters<br \/>\n5. Viewing a Stored Procedure definition<br \/>\n6. Returning values from a stored procedure<br \/>\n7. Returning result sets from stored procedures<br \/>\n8. Deterring how nested your current stored procedure is in the call stack<br \/>\n9. Encrypting Stored procedures<br \/>\n10. Creating a stored procedure that executes on instance start up<br \/>\n11.Tips on coding stored procedures<br \/>\n12.Tips on Stored Procedure Performance<br \/>\n13. CLR Stored Procedures  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Presenter: Matt Batalon Topic: Introduction to SQL Stored Procedures SQL Stored Procedures have been part of SQL Server since the early days. They are fundamental part of almost any SQL Server database. In this introductory presentation we will cover the benefits of using stored procedures in your database development projects, and also look as some [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[183],"tags":[],"class_list":["post-1071","post","type-post","status-publish","format-standard","hentry","category-2015-events"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1071"}],"version-history":[{"count":1,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1071\/revisions"}],"predecessor-version":[{"id":1072,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1071\/revisions\/1072"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}