SQLize Online / PHPize Online  /  SQLtest Online

CREATE OR ALTER procedure dbo._test1(@name varchar(32)) AS BEGIN --Select SPID = @@SPID if object_id('tempdb..#TST') is not null Select 'temp table #TST exists on start' Create table #TST( dummy varchar(32) NULL ) --Select * from #tst Declare @SQLString varchar(255) SET @SQLString = 'ALTER TABLE #TST add [' + @name + '] varchar(255) null ' EXEC ( @SQLString ) Select * from #tst drop table #TST if object_id('tempdb..#TST') is not null Select 'temp table #TST exists on STOP' END GO SELECT @@VERSION GO EXEC _test1 'column1' GO EXEC _test1 'column2' GO EXEC _test1 'column3' GO