create database nihao
go
use nihao
go
create table test
(
id int identity primary key,
shuju nvarchar(20)
)
goinsert into test values ('qq')
insert into test values ('dd''dd')
go
select * from test
go
drop database nihao
我要把插入的dddd用单引号引起来,怎么做?谢谢了
调试欢乐多
go
use nihao
go
create table test
(
id int identity primary key,
shuju nvarchar(20)
)
goinsert into test values ('qq')
insert into test values ('dd''dd')
insert into test values ('''dddd''')
go
select * from test (1 行受影响)(1 行受影响)
id shuju
----------- --------------------
1 qq
2 dd'dd
3 'dddd'
(
id int identity primary key,
shuju nvarchar(20)
)
goinsert into test(shuju) values(N'qq')
insert into test(shuju) values(N'''dddd''')
go
select * from test
go
drop table test
/*
id shuju
----------- --------------------
1 qq
2 'dddd'(所影响的行数为 2 行)
*/
insert into test(shuju) values(N'qq')不好意思,加个"N"是什么意思啊
declare @status nvarchar(20)
select @status = N'stopped'
select @status = 'stopped'实际上上述两句赋值的结果是一样的,因为变量类型就是 nvarchar(Unicode 类型)。而有些地方(比如:sp_executesql 的参数)不能自动转换,所以需要加 N 了。
QUOTENAME('DDDD','''');