Generating crud scripts from table def?

• 
  Thank you for your post into the forum.
  
  Excellent news that you are enjoying using SQL Prompt.
  
  You can create and add your snippets to use. Please vist this Web Page In the Learning SQL Prompt section, expand the topic "Speeding up your Queries" and take a look at the "Inserting snippets" and "Managing Snippets". This will help you create your own snippets to achieve your goal of automatically create / update and delete your Stored procedures.
  
  Many Thanks
  Eddie

  Eddie D January 23, 2012 09:48

  - 0 +
• 
  Hi, Eddie.
  
  Thanks for the reply. I've looked at both of the pages you recommended but there's not much detail on either one.
  
  In order for the snippet system to be able to automatically generate the create, update and delete procs based on a given table, there needs to be a way for it to take a reference to the table name, get the list of its column names and data types, and then use that in the generated code to populate the procs.
  
  Are there other sources of information that I should be referencing to understand how I accomplish this?
  
  Thanks,

  ChrisDuncanMnx January 23, 2012 09:59

  - 0 +
• 
  Have you seen the SSMS Tools Pack?
  
  http://www.ssmstoolspack.com/Features?f=12
  
  This has the ability to auto-generate CRUD Sprocs.
  
  Hope this helps,
  
  Justin

  justin.caldicott January 23, 2012 11:06

  - 0 +
• 
  Hey, Justin.
  
  Very cool, thanks for the link! Is this your stuff?

  ChrisDuncanMnx January 23, 2012 11:09

  - 0 +
• 
  Alas no!
  
  I'd be interested to hear if it solves your problem sufficiently.
  
  Thanks,
  
  Justin

  justin.caldicott January 23, 2012 11:16

  - 0 +
• 
  You still get bonus points for coming up with what looks like a great addition. Take two cookies out of petty cash. ;-)
  
  By the way, I have the Redgate tools, which means Sql Prompt is installed. Do you happen to know if there's a conflict between the two? Seems like they do similar things so I don't know if they'll get into a cat fight over every character I type.

  ChrisDuncanMnx January 23, 2012 11:19

  - 0 +
• 
  Okay, I just installed it and gave it a quick run on the crud stuff (and apparently that's just scratching the surface).
  
  Bovine deity.
  
  Man, this would have saved me a ton of work the past week. Thanks!

  ChrisDuncanMnx January 23, 2012 11:36

  - 0 +
• 
  Glad to hear it helped!
  
  Justin

  justin.caldicott January 25, 2012 09:46

  - 0 +
• 
  Not to plug the opposition (Not really) :roll:
  
  Have you looked at CodeSmith (www.CodeSmthTools.Com) , you can set up extremely comprehensive templates that generate CRUD and lots of other code . There samples show you how, even to using full blown ORM's like NHibernate . Along with their own PLINQO ones
  
  You can also Use T4 in VS to generate stuff , but it takes a bit more effort.
  
  ALSO again there are INSERT DELETE and UPDATE templates in Sql Management Studio
  
  Cheers
  
  Mike

  MikeONeill January 30, 2012 04:03

  - 0 +

Add comment

Please sign in to leave a comment.