locked
Stored Prosedures in SQL RRS feed

  • Question

  • Hi,

    I watched this video: http://msdn.microsoft.com/en-us/vbasic/bb643825.aspx..

    In this video Beth creats a Stored Prosedure for inserting costumer, and she had 2 outputs: modify and the CustomerID...

    In my db the key is other field (not auto numbering...), but there is also an auto numbering field... I don't know which of them to include in the outputs... maybe both?

    Thanks :)

    Sunday, September 26, 2010 4:42 PM

Answers

  • It depends on the situation. What you want to get as output? It does not matter it is auto increment or not. You can design a stored procedure whihc the output could be a specific data time or a calculated field. You have to know what you are looking in stored procedure to get as output. Your stored procedure does not necessarly have to have an output.

    If you want, post your stored procedure in here and say what you expect to get as output.


    Best Wishes, Arbi --- Please vote if you find this posting was helpful or Mark it as answered.
    • Marked as answer by Tom Li - MSFT Thursday, October 7, 2010 2:53 AM
    Monday, September 27, 2010 4:10 AM

All replies

  • It depends on the situation. What you want to get as output? It does not matter it is auto increment or not. You can design a stored procedure whihc the output could be a specific data time or a calculated field. You have to know what you are looking in stored procedure to get as output. Your stored procedure does not necessarly have to have an output.

    If you want, post your stored procedure in here and say what you expect to get as output.


    Best Wishes, Arbi --- Please vote if you find this posting was helpful or Mark it as answered.
    • Marked as answer by Tom Li - MSFT Thursday, October 7, 2010 2:53 AM
    Monday, September 27, 2010 4:10 AM
  • Hi OfekAlef,

      Please post the actual requirement , so that we can analyze the problem ...


    -- Reddy Balaji C. ##Mark as answer if it solves the issue
    Monday, September 27, 2010 4:26 AM
  • If you do not know which one to include why do  you think we will? It depends on your business requirements which column/value to be returned
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, September 27, 2010 5:44 AM
  • If you do not know which one to include why do  you think we will? It depends on your business requirements which column/value to be returned
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, September 27, 2010 5:44 AM