Home Forums SQL Server 7,2000 T-SQL Need help creating dynamic "USE" statement... Thanks. RE: Need help creating dynamic "USE" statement... Thanks.

  • Having fun with more dynamic dynamic sql

    DECLARE @stmt NCHAR(1000)

    SET @stmt = 'USE Frank_3 ' + CHAR(13) + 'DECLARE @stmt NCHAR(1000)' + CHAR(13) +

    'SET @stmt = ''CREATE TABLE Second (col_a int)''' + CHAR (13) +

    'EXEC sp_executesql @stmt'

    EXEC sp_executesql @stmt

    Do I need to add the reference to Erland Sommarskog again?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]