Executing SQL with named parameters causes a dialog to show up asking for the parameters.
If I have the following SQL:
EXEC sp_rename @objname='ardbPcbRelatedGames.PcbRelatedGamesID', @newname='PcbRelatedGameID', @objtype='COLUMN'
A dialog will pop up asking for the values for @objname, @newname and @objtype. Those already have values provided and it doesn't need to ask me for them.
2
votes
Brien King
shared this idea