Re: Views

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 10/05/04

  • Next message: Steve Kass: "Re: Views" 
    Date: Mon, 4 Oct 2004 23:24:43 -0500

    Hello,

    You cant use variable inside a view.

    But try creating the view using dynamic sql.

    Thanks
    Hari
    MCDBA

    "??" <anonymous@discussions.microsoft.com> wrote in message
    news:28d301c4a9fc$f9210500$a301280a@phx.gbl...
    > 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: Steve Kass: "Re: Views"