Arithmatic Overflow - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Arithmatic Overflow

Author

Topic

taylo
Yak Posting Veteran

82 Posts

Posted - 2001-03-07 : 08:09:31

I keep getting an arithmatic overflow below.
@strForm are the form values from an ASP page. it looks liek this
FirstName=1,LastName=1

CREATE PROCEDURE los_ResetAttributes

@strForm nvarchar(1000),
@userid numeric(10)

AS

declare @setAtts nvarchar(1000)

set @setAtts = 'Update loy_tblAttributes Set ' + @strForm + ' Where UserID = ' + @userid
exec(@setAtts)

Thanks,

Rob

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources