Post reply

Explain diff B/W storedProcedure and normal query

  • February 1, 2007 at 2:46 am

    #116080

    :unsureear All,

    Please explain difference between  a stored procedure and normal query with examples

    Please explain difference between  a stored procedure and stored function with examples

    i executed qurey as normal and as well as in the form of stored procedure also. But both took same time to execute.

    i think u understand me.

    so please bring me out of confusion.................................

  • February 1, 2007 at 3:25 am

    #687049

    • Read Books On Line
    • Buy Inside SQL Server Book
    • Attend appropriate training course

    This question is far too generalised. I'm sure there's a wealth of written articles on the site on this subject matter.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • February 1, 2007 at 9:37 am

    #687139

    Well put, Colin.  I just noticed another thread in this forum from someone who, apparently, needed answers to a school assignment that he didn't have time to look up himself.

     

    Greg

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

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