--批量删除表

    DECLARE @Table NVARCHAR(30)

    DECLARE tmpCur CURSOR FOR

    SELECT name FROM sys.objects WHERE TYPE='U' AND name LIKE N'%_QueryLog'  --删除所有含有"_QueryLog"的表

    OPEN tmpCur

    FETCH NEXT FROM tmpCur INTO @Table  

    WHILE @@FETCH_STATUS = 0

    BEGIN

        DECLARE @sql VARCHAR(100)

        SELECT @sql = 'drop table ' + @Table

        EXEC(@sql)

        FETCH NEXT FROM tmpCur INTO @Table

    END

    CLOSE tmpCur

    DEALLOCATE tmpCur