Are parameters permitted on SQL Server 2000 views

120 pts.
Tags:
Parameters
SQL Server 2000
SQL Server 2000 views
SQL Server views
I think the answer to this is NO, but is there a way to create a view that accepts input parameters? I created the view hard coding in something that now needs the flexibility that a parameter would provide, but I've never seen a parameter on a view - Is it possible? Thanks
ASKED: October 20, 2008  7:06 PM
UPDATED: August 20, 2010  8:05 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

No views do not accept parameters. Simply leave off that part of the where clause, and then add it when you query the view.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Joomkia
    Can crystal reports paramaters work on sql server based views?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following