From: asgars on 11 May 2010 05:28
I have a inline SQL query in a VB.NET. It is something like this...
UPDATE EMPLOYEE SET NAME = ?, CONTACT= ?, OLDCONTACT = ?,
This is working fine when i assign a value for each of '?' marks using
SQLParameter. But here i need to copy one column's value into another
column. Like I want to copy the value of CONTACT column into
I know this can be done easily by a using stored proc, like
UPDATE EMPLOYEE SET OLDCONTACT = CONTACT
(where OLDCONTACT and CONTACT are column of same table.)
How can I do it using inline query (the one shown above with question
From: Patrice on 11 May 2010 07:05
> I know this can be done easily by a using stored proc, like
> UPDATE EMPLOYEE SET OLDCONTACT = CONTACT
> (where OLDCONTACT and CONTACT are column of same table.)
Same than what you shown above with possibly a where clause. What have you
tried that doesn't work ?