Sunday, March 11, 2012

automatic code for each table - dont work

Hi,
i'm trying to automatize some tasks for each table, but this piece of code doesn't work :
...
DECLARE @.TableName sysname
...
drop table @.TableName ( or whatever ... )
...
...

the error message is: " Incorrect syntax near '@.TableName' "

Thanks !Try using EXECUTE command:

DECLARE @.TableName sysname

exec ('drop table ' + @.TableName )

No comments:

Post a Comment