Creating a view from a stored procedure 1

[TomBarrand]

I would like to create a view from within a stored procedure, but the view name needs to be a variable that is passed into the stored procedure. Is this possible? If so some example syntax would be appreciated.

Cheers

 

[tlbroadbent]

You'll need to create and execute a dynamic SQL statement. Here is a simple example.

Create procedure CreateNewView @viewname nvarchar(128) As

Declare @sql nvarchar(2000)

Select @sql=
'Create View ' + @ViewName +
' As Select * From tableA'

Exec(@sql)

Go Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.