Today i got noticed a bug in sql server 2005(also in SSMS 08) while executing a simple select statement
select 3 --(*)
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '--(*'.
If we put a space or any other characters before the "(" there is no error. Also
select 3 --)* not returning error.Any way this is a bug in sql server as it does not parse the comment statements
Also i got an error message while Parsing an sql script as
."Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded."
But the script is executing successfully and giving the accurate results!!!!
Compare Sql Server Table Constraints
13 years ago
2 comments:
Good Informations!!! Thanks Buddy!!!
issue still there in 2020
Post a Comment