Parameter Query....

[mikej336]

I am trying to create a Access style Parameter Query were the query pops up a window and asks you what to search for.

The online help says that this is an example.

SELECT title_id
FROM titleauthor
WHERE (au_id = ?)

But when I run it, it comes back with

Incorrect syntax near '?'.

Any Ideas.

Thanks

 

[SQLSister]

the short answer is you can't do that in T-SQl. THat is a problem for your user interface not t-sql.

Write a stopred proc with an input parameter. Then use your user interface to get the user to specify a value and then exec the sp with the value your user gave the interface.

Questions about posting. See faq183-874

 

[SQLDenis]

that is available in DTS (execute sql task)
you can map ? to params which can be mapped to global vars

in some languages (Java) you can have prepared statements like that also

you can not do it from query analyzer

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions