Post reply

Read Data in Store procedure

  • August 17, 2018 at 4:42 am

    #415292

    Hi  I want to read data from a table in Stored procedure . Do some calculations & update data . I want to do this in Stored Procedure itself
    Thanks

  • August 17, 2018 at 4:57 am

    #2002207

    jsshivalik - Friday, August 17, 2018 4:42 AM

    Hi  I want to read data from a table in Stored procedure . Do some calculations & update data . I want to do this in Stored Procedure itself
    Thanks

    Welcome to SSC.

    What is your question here exactly? If your asking, "Can I perform a SELECT, UPDATE, and use expressions in a Stored Procedure?" then the answer is yes. You can perform (almost) any functionality you can normally do in SSMS/SQLCMD/user interface within a Stored procedure.

    Perhaps you might be best having a look at a tutorial? https://www.w3schools.com/sql/sql_stored_procedures.asp

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply