update sql with program
In Sql Server
TblAA Table is
Column1 -> DataType-> decimal(18, 3)
Column2 -> DataType-> decimal(18, 3)
- Column1 and Column2 has at least 15 digits.
- UPDATE TblAA
- SET Column1 =Column2
- WHERE ReportType='B'
It is OK when run this statement in sql server.
update Column2 data into Column1
but when i call this statement from my program with storedprocedure
not ok completely. pls help