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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2010-08-24 : 11:27:20
|
| I got the below error in the function..Conversion failed when converting the varchar value '48.5' to data type int.select dbo.UDF_CHECK_year ('01','08','48.5') |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-24 : 11:42:24
|
your third parameter in your function is integer datatype. so you should use integer.e.g.:SELECT dbo.UDF_CHECK_Year('01','08',48) |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2010-08-24 : 14:04:24
|
| third parameter in function is not integer datatype it is a varchar type..I am checking against database values..It is not possible to use integer...Do you have any other options |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-25 : 09:52:16
|
quote:
Originally posted by sqlfresher2k7
third parameter in function is not integer datatype it is a varchar type..I am checking against database values..It is not possible to use integer...Do you have any other options
nope somewhere you're trying to assign it to integer field which is causing this error.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-08-25 : 12:20:14
|
| show the DDL of UDF_CHECK_Year() |
|
|
|
|
|
|
Error