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 )
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment