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.
| Author |
Topic |
|
suresh
Starting Member
1 Post |
 Posted - 2002-05-28 : 14:46:48
|
| HiI am using COLUMNS_UPDATED() function in a trigger on a table.The Table has 85 columns. I want to check the user is updating any column in the table. I am getting Arthemetic Over flow error in this function.I am using bigint to hold the variable.Can any one help on this.ThanksSuresh Velagasuresh.velaga@aditech.com |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-05-28 : 15:00:59
|
| columns_updated() returns a varbinary bit pattern that indicates which columns in the table were inserted or updated. i don't believe you can store that in a bigint. you should use some other datatype or process the directly in you statement and not store in a variable. See the example in BOL on the CREATE TRIGGER 'page' . . .<O> |
 |
|
|
|
|
|
COLUMNS_UPDATED