Delete From [@.ServerName].[@.ImportToDatabase].[MyTable]
Any help appreciatedno. you can't do that.
EXECUTE 'DELETE FROM [' + @.ServerName + '].[' + @.ImportToDatabase + '].[username].[MyTable]'|||For some reason this doesn't seem to work in my code. However using:
EXEC ('DELETE FROM [' + @.ServerName + '].[' + @.ImportToDatabase + '].[username].[MyTable]' )
Does work.
Thanks for your comments
No comments:
Post a Comment