Without including all of the peripheral code, I am trying to do an ALTER TABLE command using an argument in a cursor. ALTER TABLE does not seem to like the argument. Any ideas??
SET @KeyID = @TableName + '_KeyID'
ALTER TABLE @TableName ADD @KeyID INT IDENTITY(1,1) PRIMARY KEY NOT NULL
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.