locked
generating functions for insert, update, delete functions of SQL RRS feed

  • Question

  • Every time I create a database project, I've to write the queries for inserting, updating, deleting functions and for other SQL qeeries.
     
    Is there any way of creating functions for such queries and just passing the arguments for required queries as per our need?
    Monday, December 19, 2011 8:43 AM

Answers

  • Hi Kim,

    You could try the add-on suggested by Uri. Meanwhile you could provide Microsoft a feature request at https://connect.microsoft.com/SQLServer so that MS can try to modify and expand the product features based on your needs.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, December 22, 2011 3:51 AM
    Answerer

All replies

  • http://www.ssmstoolspack.com/
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, December 19, 2011 8:52 AM
  • Hi Kim,

    You could try the add-on suggested by Uri. Meanwhile you could provide Microsoft a feature request at https://connect.microsoft.com/SQLServer so that MS can try to modify and expand the product features based on your needs.


    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Thursday, December 22, 2011 3:51 AM
    Answerer
  • Hi

      Try to use template.

    template will give you ability to change your parameters and put you table name and so on.

     

    if it helpful please mark it as answered.

     

    Elmozamil Elamir

    http://elmozamil.blogspot.com

    Monday, December 26, 2011 6:39 AM
  • http://www.ssmstoolspack.com/
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

    I would have proposed this as the answer however you have provided very little in the way of assistance to the OP. You should at least write some sort of an explanation instead of just providing a link!


    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    Wednesday, December 28, 2011 3:10 AM