All Questions
2 questions
0
votes
0
answers
56
views
TSQL converting varchar to int - numeric say 1 and I get a point '.' at the end of the varchar?
I am facing a problem with the convertion of a varchar in a numeric value.
I have following SQL Code
DECLARE @Test varchar --f.e. '12345'
DECLARE @TestNum int
.......
IF ISNUMERIC(@Test)=1 then
...
- 9
1
vote
1
answer
21k
views
Error converting data type numeric to int
I have two databases on the same SQL Server. Same code.
I have a stored procedure with an input parameter @Test INT. In one database when I pass a NUMERIC value into that input, it gets truncated ...
- 159