Results 1 to 4 of 4

Thread: Prompting for Value (Parameter)

  1. #1
    Join Date
    Sep 2007
    Posts
    8

    Prompting for Value (Parameter)

    I need assistance in writing a script that will prompt for a Date value while reading data from a Table. The Table will contain data for a whole month; I need to be able to pull all data for a particular date, but must be prompted to enter the date and the value will be passed back to the query/script in order to retrieve the specific date.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Can't do that in t-sql.

  3. #3
    Join Date
    Sep 2007
    Posts
    8

    Prompting for Value (Parameter)

    I am trying to do it in MS SQL. I may have posted in the wrong Group.

    Is it possible in MS SQL?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    MS sql server uses t-sql. You may need write some vb script or so to make it work.

Posting Permissions

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