View Single Post
  #6  
Old 07-29-2013, 12:11 PM
sorvani
Dragon
 
Join Date: May 2010
Posts: 965
Default

if you really like variables for no reason (it is a single statement, but I guess you could make a loop or just easier copy/paste), use as appropriate in the above statement:

Code:
SET @CopyFrom = 12345;
SET @CopyTo = 12346;
SET @NewName = 'Bob';
Reply With Quote