C
cgwozdz
I am new to SQL Server and I'm trying to create a parameter query in the View
folder in SQL Server. I used @name as well as a ? mark for the parameter,
but I continue to get a message stating that "'Parameters' cannot be used in
this query type."
After I get the error, I am able to run the query - the parameter dialog
pops up and the result set is accurate. However, when I try to save the view,
a dialog pops up stating the I must declare the scalar variable "@name".
I click OK and receive the message "User canceled out of save dialog".....
What am I missing?
Thanks,
_____Casey G.
folder in SQL Server. I used @name as well as a ? mark for the parameter,
but I continue to get a message stating that "'Parameters' cannot be used in
this query type."
After I get the error, I am able to run the query - the parameter dialog
pops up and the result set is accurate. However, when I try to save the view,
a dialog pops up stating the I must declare the scalar variable "@name".
I click OK and receive the message "User canceled out of save dialog".....
What am I missing?
Thanks,
_____Casey G.