Solved

SQL Server Script Prompt

Posted on 2010-08-14
3
407 Views
Last Modified: 2012-05-10
In my SQL query i am using the following parameters for users to input values

userid= 'N[&1]' , something like this customercode= 'N[&2]'  

Is there any other way for user to get prompt to input values ??

should work in MS SQL and T-SQL

'[%0]' SOMETHING LIKE THIS
0
Comment
Question by:DESAIY
3 Comments
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 250 total points
ID: 33439944
This depends entirely on your development environment.
In Sql Server Management Studio, there is no such thing as a parameter prompt like the one Access has.
0
 
LVL 13

Assisted Solution

by:p_nuts
p_nuts earned 250 total points
ID: 33440712
in reporting services it's done through @varname.

in most other programming languages you have to build the interaction..
0
 

Author Comment

by:DESAIY
ID: 33441743
Thank you guys for your response. much appreciated.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
tempdb log keep growing 7 33
SQL, How to do aggregation on extracting field and range band field? 2 30
SQL Query 2 31
Get Next number from Stored Procedure 8 21
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question