When specifying a value with a single quote, you need to double it.
SELECT 'Hello''s'
Returns: Hello's
About Me
- Jesse
- has 6+ years experience as database administrator in MS SQL Server 2000/2005/2008/2008 R2, 2012. He has a bachelor of Science Degree in Computer Science along with MCP (Microsoft Certified Professional), MCTS(Microsoft Certified Technology Specialist), Certificate in Application Programming Technique (SAP – ABAP/4), Certificate in Client Server Technology (SAP), Certificate in Business Process Engineering (SAP), Certificate in Enterprise Resource Planning (SAP). He is currently undertaking his Master of Business(Enterprise Resource Planning) Degree part-time.
No comments:
Post a Comment