I am writting a dynamic sql to drop and create view in different database.
So I wrote:
set @CreateViewStatement = ' USE ['+ @DB +']; CREATE VIEW [dbo].[MyTable] AS SELECT ........something exec (@CreateViewStatement)
It gives me error:
'CREATE VIEW' must be the first statement in a query batch.
If I remove the USE DATABASE statement it works fine, but then the database is not specify anymore....
How can I solve this problem?