Post reply

Is it possible to create a VIEW from within a stored procedure?

  • April 6, 2005 at 1:22 pm

    #166538

    I know I can create a table within, but it doesn't seem to like VIEWS!

  • April 6, 2005 at 1:43 pm

    #550941

    You can if it's dynamic sql within an exec statement.. something like this is possible :

    Create proc a

    AS

    exec('

    create view b

    as

    select getdate() as Today'

    )

    GO

    exec a

    select * from b

    drop proc a

    drop view b

  • April 7, 2005 at 6:56 am

    #551125

    Excellent. Thanks a bunch. I'm having to great a stored proc for a large VIEW, instead of having it inside the TSQL JOBs window which is foolishly truncated to only 3000 characters.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply