Tool to generate CRUD stored procedures?

• 
  @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!

  Tianjiao_Li January 24, 2020 14:36

  - 0 +
• 
  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 ...

  jensgc January 24, 2020 14:40

  - 0 +
• 
  @jensgc
  
  Thanks for your vote!
  
  If you haven't tried, it might be worth trying custom snippets in the meantime.
  

  Tianjiao_Li February 04, 2020 10:56

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

  thoitrangtadi February 21, 2020 08:35

  - 0 +
• 
  Yes - that is exactly what I want, thoitrangtadi.
  
  SSMS Tools has the CREATE CRUD option, but it is missing in SQL Toolbelt.
  
  
  
  

  jensgc February 24, 2020 15:00

  - 0 +
• 
  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/

  Impkeys April 03, 2020 20:57

  - 0 +

Add comment

Please sign in to leave a comment.