How to assign value of one column to another using Inline sql query?
in [ASP .NET]
|
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 OLDCONTACT column. 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 marks)???
From: Patrice on 11 May 2010 07:05 Hello, > 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 ? -- Patrice
|
Pages: 1 Prev: Modal popup with gridview row detail Next: asp.net C# calling VB dll function |