Go Premium for a chance to win a PS4. Enter to Win

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

parameterized queries and views

Hi

Am i correct in saying you cant create parameterized queries against views in sql server 2000/2005?

Is this is correct, how do you 'get round' this limitation

Thanks
amdrea
0
andieje
Asked:
andieje
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
use stored functions instead of views to have parametrized query
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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