how can i update email address which is nvarchar(200) to add in additional date and notes? Example: abc@yahoo.com update to abc_NEW20121114@yahoo.com I tried as below but hit this error 'Conversion failed when converting date and/or time from character string'
DECLARE @email nvarchar(200) DECLARE @date datetime SET @userName= 'abc@yahoo.com' SET @date= GETDATE() Update tableA set email= @userName+@date where email= @userName
update additional note
Posted - 11/13/2012 : 21:28:59
