Execute StoreProcedure paramters

  • Hi, I would like to execute the parameters of the storeprocedure. bcz I would like to know what the parameters value I am passing through asp.net page. please advice!

  • What??? Need to provide a good bit more detail on your problem.

    First: You will not be able to "execute the parameter of the storeprocedure" by themselves. You execute the stored procedure and pass the parameter through the execution.

    If you know the name of the stored procedure you can view the code through SSMS.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • Yep, sorry, parsed this sentence multiple times and I'm still confused.

    Could you explain in a bit more detail what it is that you're trying to do?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • reach2sam (9/17/2009)


    Hi, I would like to execute the parameters of the storeprocedure. bcz I would like to know what the parameters value I am passing through asp.net page. please advice!

    My brain!... my brain!

    Seriously... could you rephrase?

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 4 posts - 1 through 3 (of 3 total)

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