{"id":203,"date":"2010-12-23T17:18:43","date_gmt":"2010-12-23T22:18:43","guid":{"rendered":"http:\/\/www.compdigitec.com\/labs\/?p=203"},"modified":"2010-12-23T17:18:43","modified_gmt":"2010-12-23T22:18:43","slug":"quickly-generate-crud-stored-procs-in-ssms-with-ssms-tools-pack","status":"publish","type":"post","link":"https:\/\/www.compdigitec.com\/labs\/2010\/12\/23\/quickly-generate-crud-stored-procs-in-ssms-with-ssms-tools-pack\/","title":{"rendered":"Quickly generate CRUD (Create, read, update, delete) stored procedures in SSMS with SSMS Tools Pack"},"content":{"rendered":"<div style=\"width: 624px\" class=\"wp-caption alignnone\"><a href=\"\/images\/labs\/ssms.png\"><img decoding=\"async\" loading=\"lazy\" title=\"SSMS Tools Pack generated CRUD\" src=\"\/images\/labs\/ssms.png\" alt=\"SSMS Tools Pack generated CRUD\" width=\"614\" height=\"424\" \/><\/a><p class=\"wp-caption-text\">SSMS Tools Pack generated CRUD<\/p><\/div>\n<p>Normally, in <strong>SQL Server Management Studio<\/strong> to generate some stored procedures one would have to go through series of dialogs and manual actions using the &#8220;Script To&#8221; menu. This process is both painful to do by hand and is also very error-prone. Now there is an automated tool that can automate the process of writing stored procedures for us &#8211; <a href=\"http:\/\/www.ssmstoolspack.com\/\">SSMS Tools Pack<\/a>.<\/p>\n<p>To automatically generate the select, insert, update and delete procedures all one must do (after installing the free add-on), is right click on a table, go to &#8220;<strong>SSMS Tools<\/strong>&#8221; and &#8220;<strong>Generate CRUD<\/strong>&#8220;, and then <strong>Execute<\/strong> the query that it generates. This makes database development much easier compared to doing it by hand.<\/p>","protected":false},"excerpt":{"rendered":"<p>Normally, in SQL Server Management Studio to generate some stored procedures one would have to go through series of dialogs and manual actions using the &#8220;Script To&#8221; menu. This process is both painful to do by hand and is also very error-prone. Now there is an automated tool that can automate the process of writing [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[737,738,698,740,739,741,60],"_links":{"self":[{"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts\/203"}],"collection":[{"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/comments?post=203"}],"version-history":[{"count":0,"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/posts\/203\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/media?parent=203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/categories?post=203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.compdigitec.com\/labs\/wp-json\/wp\/v2\/tags?post=203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}