March 3, 2020 at 3:10 pm
Hi,
I'm getting an obscure issue when
when I run this SQL statement
SELECT TOP 1 S_Date from tbl_name order by RowID
I get this error message :
Msg 9807, Level 16, State 0, Line 1
The input character string does not follow style 112, either change the input character string or use a different style.
but it is OK when I leave out the "order by RowID".
Both SQL Statements will return the same first row and the value of S_Date is NULL and is of type date
Any help welcome!!!
Thanks,
Eamon
March 3, 2020 at 3:11 pm
What is the DataType of RowId?
March 3, 2020 at 6:21 pm
are you sure that tbl_name is really a table and not a view?
that SQL so simple would give that error if it was from a view with invalid data on the underlying table(s)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy