Compdigitec Labs

« | Home | »

Quickly generate CRUD (Create, read, update, delete) stored procedures in SSMS with SSMS Tools Pack

By admin | December 23, 2010

SSMS Tools Pack generated CRUD

SSMS Tools Pack generated CRUD

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 “Script To” 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 - SSMS Tools Pack.

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 “SSMS Tools” and “Generate CRUD“, and then Execute the query that it generates. This makes database development much easier compared to doing it by hand.

If you found this article helpful or interesting, please help Compdigitec spread the word. Don’t forget to subscribe to Compdigitec Labs for more useful and interesting articles!

Topics: Windows | 3 Comments »

3 Responses to “Quickly generate CRUD (Create, read, update, delete) stored procedures in SSMS with SSMS Tools Pack”

  1. alili Says:
    March 31st, 2011 at 8:16 am

    when you generate the stored procedure with ssms tools. why the update operation update the key
    and why it use also select

    thanks for you response

  2. Nancy Says:
    October 2nd, 2012 at 9:55 pm


  3. TonyGonzalez Says:
    June 12th, 2018 at 6:36 am

    Thank for the information, very interesting!
    I’d like to share my humble opinion and add one more great tool to this list. It’s
    dbForge Developer Bundle for SQL Server and it’s really must-have for me in my daily development routine. This set of tools gives me full control over database development and management and allows me to version-control databases, compare schemas and data, optimize database performance, write SQL queries on-the-fly and generate meaningful test data. Recommend it!