Viết dấu " ' " trong SQL server

[Pham_Hoai_Nam (!isProgrammer)]

Em muốn dùng query để insert item có text chứa dấu ’ , vậy làm như nào ạ

Cả khi truy vấn nữa làm thế nào để truy vấn Name có dấu ’ mà không báo lỗi

VD phần mềm này cũng cho insert dữ liệu có text chứa dấu ’

[noname00 (HK boy)]

Thử

''

hoặc

\'

Ví dụ

'làm ''Toán'' vui'
'làm \'toán\' vui'

[Pham_Hoai_Nam (!isProgrammer)]

Incorrect syntax near ‘toán’.

biên dịch không lỗi nhưng chạy không hiển thị

[hungaya (Hung)]

Character string constants are enclosed in single quotation marks and include alphanumeric characters (a-z, A-Z, and 0-9) and special characters, such as exclamation point (!), at sign (@), and number sign (#). Character string constants are assigned the default collation of the current database, unless the COLLATE clause is used to specify a collation. Character strings typed by users are evaluated through the code page of the computer and are translated to the database default code page if it is required.

If a character string enclosed in single quotation marks contains an embedded quotation mark, represent the embedded single quotation mark with two single quotation marks. This is not required in strings embedded in double quotation marks.

Example

'Cincinnati'  
'O''Brien'  
'Process X is 50% complete.'  
'The level for job_id: %d should be between %d and %d.'  
"O'Brien" 

Link: https://docs.microsoft.com/en-us/sql/t-sql/data-types/constants-transact-sql?view=sql-server-2017

---

SELECT *
FROM dbo.BoMon
WHERE Name = 'làm ''Toán '' vui'