Results 1 to 9 of 9
  1. #1
    Join Date
    May 2004
    Posts
    9

    Unanswered: question mark in T-SQL

    Hello Experts,

    What is the use of question mark "?" in T-SQL?

    Thanks in advance!






    ------------------------------------------------------
    We took the European Cup, will take the World Cup.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The question mark symbol is used to designate the end of an interogatory statement on SQL Server forum postings. Do you understand now?

    Other than that, nada that I can think of. Where did you see it?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95
    I assume you have seen it somewhere so why not show us the code and then some one might understand how to answer you
    Sorry to be terse
    some say it's a curse
    I know it's worse
    I'm just diverse

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    If you import a spreadhsheet it can appear at the end of the imported table name. other than that I got nothing

  5. #5
    Join Date
    May 2004
    Posts
    9

    Re: question mark "?" in T-SQL

    Ok guys see this simple code below:

    CREATE PROCEDURE [sp_1]

    @a? as int

    AS

    print 'bla bla'
    GO

    the error message that appears when you check the syntax is the following:
    Error 0:COUNT field incorrect or syntax error.

    I think that COUNT means something but what?? Maybe nothing, I don't know, I had to answer.

    Thanks in advance!

    ---------------------------
    Will take world cup (soccer)

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    A ? is a null indicator in DB2....Are you sure you know what platform you're on?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    May 2004
    Posts
    9
    isn't the dollar symbol that appears?

    Quote Originally Posted by Thrasymachus
    If you import a spreadhsheet it can appear at the end of the imported table name. other than that I got nothing

  8. #8
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040

    Post

    The "?" can be used as a parameter marker when an sproc is called from an ODBC process. For more information, look up parameterization in BOL.

  9. #9
    Join Date
    May 2004
    Posts
    9
    That's true thank you much tomh!

    Quote Originally Posted by tomh53
    The "?" can be used as a parameter marker when an sproc is called from an ODBC process. For more information, look up parameterization in BOL.

Posting Permissions

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