Post reply

Entering Value by the User

  • December 13, 2013 at 4:04 pm

    #395988

    I am trying to write a query which user be able to enter data after getting message for example: "Enter Value for Descriptionparam: "

    here is my query:

    select * from tablename

    where descriotion = @'%descriptionparam%'

    Any help would be really appreciated. Thanks

  • December 13, 2013 at 6:18 pm

    #1673437

    What language are you using to present the message and store the answer? SQL Server isn't real handy about doing things that should be done in the GUI. It's a storage and data manipulation engine... not a GUI design tool.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • December 15, 2013 at 8:11 am

    #1673532

    please note that the very same question (just slightly rephrased) can be found at


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • December 15, 2013 at 9:01 am

    #1673539

    LutzM (12/15/2013)

    please note that the very same question (just slightly rephrased) can be found at

    Just to make it easier:

    http://www.sqlservercentral.com/Forums/FindPost1522894.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply