July 5, 2006 at 5:12 pm
Hello
If i use the enterprise manager, choose the database and select a table and build a query based on this table , on the criteria pane i can put ? as a parameter to prompt before running, what the value of my parameter.
example :
select reference,quantity from sl where sl.code = ?
but in Query Analyser, if i use the same select , the same one don´t run because all the time occur one error.
I would like to know , using QA how can i use parameter(s)
Many thanks
Luis Santos
July 5, 2006 at 5:32 pm
declare @param varchar(50)
select @param = 'abc'
select reference,quantity from sl where sl.code = @param
N 56°04'39.16"
E 12°55'05.25"
July 5, 2006 at 5:41 pm
Hello Peter
Ok, your code work fine , but i must declare and fixed the value of the parameter, but what i want is when i click for running the query, QA open to me an input box for specify what the desired value .
is it possible ??
Thanks
Luis Santos
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply