Home Forums SQL Server 2008 T-SQL (SS2K8) set a local variable RE: set a local variable
nikki123
Ten Centuries
Points: 1338
More actions
February 24, 2015 at 10:45 am
#1779679
Used this SET @SQL3 = 'INSERT INTO ' + '2009' + '.dbo.ALLFILENAMES(WHICHFILE) EXEC Master..xp_cmdShell ''' + @cmd1 + ''''
Its working now thank you