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

    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
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If you mean you need to assign a constant, I'd recommend that you do something like:
    Code:
    DECLARE @d DATETIME
    
    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.

    -PatP
    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
  •