There are thousand of birthdays, I can use a SELECT, of course, but it will
be better having a VIEW.

Or I can have a Stored Procedure with input parameters, that's my option.

Greetings.

On Wed, Mar 30, 2011 at 7:02 PM, W O <sistemas2000profesional@...>wrote:

> Hello Michael
>
> But that is a SELECT, not a VIEW.
>
> I want to use parameters with CREATE VIEW.
>
> Greetings.
>
>
>
>
> On Wed, Mar 30, 2011 at 5:02 PM, Michael Ludwig <milu71@...> wrote:
>
>>
>>
>> W O schrieb am 29.03.2011 um 14:29 (-0400):
>>
>> >
>> > There is some way for use a view with distinct data?
>> >
>> > For example, to use the same view when the birthday's date is
>> > '01.01.2001' or '29.03.2002'. Of course, birthday's date is a column
>> > of the table.
>>
>> Just use a WHERE clause:
>>
>> SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '29.03.2002';
>> SELECT NAME FROM V_PEOPLE WHERE BIRTHDAY = '01.01.2001';
>>
>> --
>> Michael Ludwig
>>
>>
>
>


[Non-text portions of this message have been removed]