Solved

SQL Server Script Prompt

Posted on 2010-08-14
3
410 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

751 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