Prompt for user input in criteria field of view

Hot Topic

What's Happened to Copy Objects in Import/Export Wizard?
Application as service inside SQL possible?
Importing an XML file with hirarchial data
SMSS templates
SSIS Package is "hanging" after validation
try to setup membership with ASP.NET configuration
Changing SSRS reports datasource.
multiple prediction targets
ForEach Config validation errors
Cluster installation & Domain Group requirements...

SQL Server

Right-Click Table -> Import data GONE??
Partitioned View not updatable ???
Expression with fields from different datasets
Distribution
Internet integration
yukon's transactional replication
Connecting to SQL 2005 from other machines
Query Results Truncated in SSMS
Data Source / ODBC error
DateTime and Date problem

Prompt for user input in criteria field of view

In Access, I use [Enter Date] in the Criteria field of the Query. I tried the same thing in SQL Server in the Criteria field of the View and it does not recognize this. Is there a comparable command in SQL to get user input into the Criteria field of a view



Answer this question

Prompt for user input in criteria field of view

  • GrkEngineer

    Hi,

    you either have to use a procedure with an input parameter or have to put a condition on the query with querying the view with:

    Select * from SomeView Where SomeColumn = 'SomeValue'

    But there is no GUI on SQL Server.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • samujob

    MSSQL as service prompts you nothing. You have to write client application to be prompted.

  • Jack Patrick

    Hi Jens,

    I was able to find out how to do what I needed using the @ sign (i.e. @Date Required ). In the criteria field of the SQL view, this generates a 'Date Required ' prompt box when running the view.

    Thanks anyway!

    Ernie
  • Prompt for user input in criteria field of view
Answer this question