Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2010

    Unanswered: Set date parameters within Stored Procedures

    I need to set date parameters within Stored Procedures using a sql 2008 R2, with an access 2007 front end. The procedure needs to allow me to set parameters for a start date and an end date.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    If you mean you need to assign a constant, I'd recommend that you do something like:
    SET @d = '2012-02-15 17:05'
    If you are thinking that a stored procedure can somehow determine what programming language and environment is being used by a connection, then can modify the environment on the client computer... I'm pretty sure that SQL Server can't do that.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts