Post reply

Interactive query

  • November 13, 2013 at 7:08 pm

    #286235

    I am not sure if 2k8 or higher supports interactive query, does anyone know any work around to write some query to accept keyboard input? or it is just not possible in SQL

  • November 14, 2013 at 5:51 am

    #1666341

    the accepting of parameters interactively would be part of an application, which just happens to call the SQL script when it's ready.

    SQLPlus for oracle has that feature built in, but of course SQL Server Management Studio does not.

    what with the requirement for validation and avoiding SQL Injection, you could build an application or web page that does all those things, but I don't know of any off the shelf utilities that do it.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

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