如何把'(单引号)作为一个字符插入到SQL Server的数据库中?

如何把'(单引号)作为一个字符插入到SQL Server的数据库中?
---------------------------------------------------------------

用''就行了
---------------------------------------------------------------

create table tab1(name char(10))
go
insert into tab1(name) values('''a''a''')
go
select * from tab1
--'a'a'

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus