creating aview takes parameter

Question

0.00/5 (No votes)

See more:

hiii all
i want to make aview in sqlserver 2008 . this view will take aparmeter and return some columns.

i tried to make that

<br />
Select customer, name from scheme.custm Where customer=?<br />

but there was an error

VB

There's a SQL Syntax error message - "Parameters cannot be used in this query type."

any help,
thanks

Posted 5-Feb-11 22:14pm

moon2011

Add a Solution

Comments

Abdul Quader Mamun 6-Feb-11 4:26am

Use Store Procedure.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Espen Harlinn · Answer 1 · 2011-02-05T22:30:00

Solution 1

Views can not take parameters.

You can either create a stored procedure, or create the view and select from the view using a parameterized query.

Regards
Espen Harlinn

Posted 5-Feb-11 22:30pm

Espen Harlinn

Comments

fjdiewornncalwe 6-Feb-11 11:05am

+5. Simple and complete. I like the fact that you didn't suggest to him the methodology that would allow direct access to his db objects.

Espen Harlinn 6-Feb-11 11:19am

Thanks Marcus!