Could you please help me out,
How to write an update Query to update the row with the current system date and I need to add a prefix like "ABC_"
The Column is in VARCHAR datatype.
I need it like ABC_System date
update Table1 set column1= getdate()
updates the row when i add prefix,it throws Syntax error converting datetime from character string.
Thanks in advance
View Complete Post