22,206
社区成员
发帖
与我相关
我的任务
分享
select * from Employee where EmployeeName = N'1Å'
--> 测试数据: @tb
declare @tb table (EmployeeID int,EmployeeName Nvarchar(2))
insert into @tb
select 1,N'1Å' UNION
SELECT 2,N'B'
select * from @tb where EmployeeName = N'1Å'
EmployeeID EmployeeName
----------- ------------
1 1Å
(1 行受影响)
select * from Employee where EmployeeName = N'1Å'
字段用NVARCHAR类型,
插入前加N''