插入的字段值中要求有单引号

Question

嗯，谢谢，我正在试呢：)
刚开始用：'\'aa\,,','\'bb\,,',不行

Answer 1

declare @a table(a1 nvarchar(50),a2 varchar(50))
insert into @a(a1,a2)
select '122','''456'''
select * from @a

Answer 2

insert into BRANCHSPECIALTY (branchSpecID,branchID,grade,specialtyID,creditValue) values('11090640996049126475616','10643281981151330847222','20051','''10982380443183912921362',','0')