Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

SQL Server Script Prompt

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
DESAIY
Asked:
DESAIY
2 Solutions
 
cyberkiwiCommented:
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
 
p_nutsCommented:
in reporting services it's done through @varname.

in most other programming languages you have to build the interaction..
0
 
DESAIYAuthor Commented:
Thank you guys for your response. much appreciated.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now