Home Forums SQL Server 2008 SQL Server Newbies Replacing fixed data in a WHERE clause with dynamic data RE: Replacing fixed data in a WHERE clause with dynamic data

  • January 5, 2013 at 10:19 am

    #1574057

    michael.newman560 (1/5/2013)

    I assume that the two statements directly below the procedure name, "@inFromDate" and "@inToDate" are just two variables for the WHERE clause to use. Where do they get their values from?

    They're passed as parameters from the application. You're looking for the ADO.net parameters collection.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass