set @sql='select * from character as tab1 where ''' + @realmkors +''' like realmkor 'print @realmkors
print @sql
输出
----------------------------------------
노르간논
select * from character as tab1 where '????' like realmkor
---------------------------------------为什么 @realmkors 在@sql中是乱码
set @sql='select * from character as tab1 where N''' + @realmkors +''' like realmkor 'print @realmkors
print @sql
----------------
노르간논
select * from character as tab1 where N'????' like realmkor
set @sql='select * from character as tab1 where ''' + @realmkors +''' like realmkor 'print @realmkors
print @sql---------输出---------
노르간논
select * from character as tab1 where '????' like realmkor
--try
declare @realmkors nvarchar(100),@sql nvarchar(1000)
set @realmkors = N'노르간논'
set @sql=N'select * from character as tab1 where ''' + @realmkors +''' like realmkor 'print @realmkors
print @sql
declare @realmkors nvarchar(100);set @realmkors = N'노르간논'
declare @sql nvarchar(1000)
set @sql=N'select * from character as tab1 where '''+@realmkors+''' like realmkor'print @realmkors
print @sql
/*
노르간논
select * from character as tab1 where '노르간논' like realmkor
*/