January 27, 2004 at 11:45 am
Hi,
Is there an option in Sql2k that allows a user to receive a prompt to enter the value? For e.g,
Select last, city, state
from customer where city = '&city'
It should prompt a should to enter the value for 'City'.
Any help would be appreciated.
Regards
January 27, 2004 at 1:48 pm
No, I don't know of any. There is no such feature as parameterized queries in Access, which prompt you at runtime for a value of a parameter.
However, you can write a stored procedure that accepts such a parameter and returns the data.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 27, 2004 at 11:49 pm
I concur with Frank. Also since SQL2K is the "BACK END" you should create a stored procedure that accepts parameters and then have a "FRONT END" application pass those parameters to the SP. The front end app can be written in many different programming languages.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply