Results 1 to 6 of 6

Thread: Any T-SQL geeks out there?

  1. #1
    Veteran Member Snappa's Avatar
    Joined
    Jan 2008
    Location
    FL
    Posts
    237
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Any T-SQL geeks out there?

    I'm looking for a script to generate a create script for CRUD stored procs for every table in a given database. My buddy at work has one, but it's Saturday and I was hoping to get some work done on a personal project this weekend. The one he has will generate an insert, update, delete, retrieve (by primarykey), and retrieveall (result set of all records) for a given DB.
    -Snappa-

  2. #2
    God/dess Lysondra's Avatar
    Joined
    Apr 2005
    Location
    Another Country
    Posts
    18,664
    Thanks
    0
    Thanked 148 Times in 100 Posts

    Default Re: Any T-SQL geeks out there?

    How much you payin'?


    Look like a woman
    Think like a man
    Act like a lady
    Work like a dog

    - My Great Grandmother Bessie's Recipe for Success

  3. #3
    Veteran Member Snappa's Avatar
    Joined
    Jan 2008
    Location
    FL
    Posts
    237
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Default Re: Any T-SQL geeks out there?

    Quote Originally Posted by Lysondra View Post
    How much you payin'?
    Just found an add-in that does all that and more for free, so um, nothing. This is blue side, after all. I was hoping someone would help a brother out out of solidarity.
    http://www.ssmstoolspack.com/
    -Snappa-

  4. #4
    God/dess
    Joined
    Jan 2004
    Location
    Your imagination
    Posts
    2,875
    Thanks
    19
    Thanked 174 Times in 119 Posts

    Default Re: Any T-SQL geeks out there?

    rofl.

  5. #5
    God/dess Lysondra's Avatar
    Joined
    Apr 2005
    Location
    Another Country
    Posts
    18,664
    Thanks
    0
    Thanked 148 Times in 100 Posts

    Default Re: Any T-SQL geeks out there?

    Ha, miabella and I agree on something.


    Look like a woman
    Think like a man
    Act like a lady
    Work like a dog

    - My Great Grandmother Bessie's Recipe for Success

  6. #6
    The Jackal
    Guest

    Default Re: Any T-SQL geeks out there?

    I know this is an old post and Snappa probably is long gone but I want to write this for the benefits of others. You do not need a third party tool to create stored procedure which will do CRUD. Just open up a text editor and start typing your T-SQL codes. After you are done, test it by executing it in the query analyzer.

    As an extra note, you should not combine all your Create, Read, Update and Delete logic in one stored procedure unless you have good reason to do so. They should be encapsulated inside separate stored procedures.

Similar Threads

  1. Band Geeks!
    By rozz in forum The Lounge
    Replies: 28
    Last Post: 05-24-2007, 04:35 PM
  2. Any Computer Geeks Around?
    By sc0101 in forum The Lounge
    Replies: 19
    Last Post: 03-22-2007, 03:50 PM
  3. Geeks gone wild...
    By Madcap in forum The Lounge
    Replies: 0
    Last Post: 04-19-2005, 08:53 PM
  4. For all you internet geeks.....
    By TigersMilk in forum Music Mix
    Replies: 9
    Last Post: 03-22-2005, 09:50 PM
  5. THANK YOU to all the computer geeks here!!!
    By IACali in forum The Lounge
    Replies: 5
    Last Post: 03-19-2005, 08:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •