Re: Views
From: Steve Kass (skass_at_drew.edu)
Date: 10/05/04
- Next message: Yaocuauhtzin: "SQL 2000 fails to detect NULL values"
- Previous message: Hari Prasad: "Re: Views"
- In reply to: ??: "Views"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 05 Oct 2004 02:18:46 -0400
Perhaps a table-valued function will do what you want:
create function zz (
@user int
) returns table as return
select ...
where userColumn = @user
SK
?? wrote:
>Is it possible to use variables in a view...
>Ex: Create view zz as
>Declare @user
>Set @user = 1
>Select * from sometable where @user = 1
>
>i think you get my idea...
>Is it possible?
>
>
- Next message: Yaocuauhtzin: "SQL 2000 fails to detect NULL values"
- Previous message: Hari Prasad: "Re: Views"
- In reply to: ??: "Views"
- Messages sorted by: [ date ] [ thread ]
