Tool to generate CRUD stored procedures?

jensgc

Hi all. I was trying to find a tool to help making CRUD procedures for tables. I found an old forum post (from 2012) referring to SSMS Tool Pack (https://www.ssmstoolspack.com/). I've tried the SSMS Tool Pack which seems to work fine - but I'm a bit curious to know if this feature have been considered by the RedGate team.

I prefer not to mix too many third party providers, so if there was an existing way of generating the procedures using one of the tools from the Redgate Suite, I would use that. But I haven't been able to find newer information than the 2012 forum thread. 

Tianjiao_Li

@jensgc

This is unfortunately not available in SQL Prompt at the moment. It would be really helpful if you could cast your vote on this feature request https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/3865748-create-crud

Thanks!

jensgc

Thanks for the reply. I have voted for the feature request - but given that the request is from 2013 and is still not implementet or even commented from RedGate it seems to be difficult ...

Tianjiao_Li

@jensgc

Thanks for your vote!

If you haven't tried, it might be worth trying custom snippets in the meantime.

thoitrangtadi

you would want a tool or script to generate simple CRUD stored procedures and have them in a standard format.

jensgc

Yes - that is exactly what I want, thoitrangtadi.

SSMS Tools has the CREATE CRUD option, but it is missing in SQL Toolbelt.

Impkeys

Most database systems operate on the basis of 4 simplest data manipulation operations that are called by the acronym CRUD. This acronym stands for Create, Read, Update, and Delete.

When developing and managing databases, you can use CRUD stored procedures to perform all data-related tasks. The benefit of such stored procedures is that, once they’re written once, they can be reused as many times as required, with no need to write new code each time. 

https://www.impkeys.com/