Unclosed quotation mark after the character string in SQL
Issue:Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark after the character string ''.
Issue Reason: Apostrophe (') is used in sql to start and end the string.So including Apostrophe (') in any string or varchar values will throw the above error.
for eg: if you run below query it will thrown the above error
Select 'Indian's'
Msg 105, Level 15, State 1, Line 1
Unclosed quotation mark after the character string ''.
Solution:To fix this issue you need to add one more Apostrophe (')
Select 'Indian''s'
Output:Indian's
Note :when Inserting the values containing Apostrophe (') from your web application or system applications into SQL you can replace the Apostrophe (') with double Apostrophe ('') by using Replace Function.