July 11, 2012 at 11:44 pm
Hi,
When i am using SQL Server 2008,im writing update query by using the following query
update PackingHdr set Remarks = 'ABC' where Remarks IS NULL
but it is not possible in SQL Server 2008.when writing this query the error will occur i.e.,
Msg 8115, level 16, state 8, procedure tiud_Tablename, Line 40 Arithmetic overflow error converting into data type numeric.
Can you pls help me........................
Thanking you,
July 11, 2012 at 11:58 pm
rimitha.p (7/11/2012)
Hi,When i am using SQL Server 2008,im writing update query by using the following query
update PackingHdr set Remarks = 'ABC' where Remarks IS NULL
but it is not possible in SQL Server 2008.when writing this query the error will occur i.e.,
Msg 8115, level 16, state 8, procedure tiud_Tablename, Line 40 Arithmetic overflow error converting into data type numeric.
Can you pls help me........................
Thanking you,
What is the datatype of 'Remarks' ?
It is always better to put the Table DDL and sample DML for understanding the query at our end.So please do follow.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
July 12, 2012 at 5:26 am
Sounds like you are trying to update a column that has a numeric datatype with text..
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply