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 |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
 Posted - 2004-12-21 : 09:56:33
|
| hello,when i use the set @transctnID = scope_identity()what data type would the scope_identity() function be ? Should i use convert(int,scope_identity())I am getting an error in my code and trying to debug it.The error is [CODE](1 row(s) affected)Server: Msg 8114, Level 16, State 4, Procedure Financials_PO_Core, Line 0Error converting data type varchar to int.The statement has been terminated.[/CODE]and i am wondering if its an integer value.REason is because i declared the @transactnID as int , however during execution, i get the above error message.Do i convert it to int ?thanks |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-12-21 : 10:14:42
|
| I think you might be looking in the wrong place...It appears you are trying to insert a non-numeric value into an int datatype field. |
 |
|
|
|
|
|
What data type is set @transctnID = scope_identity