Home Forums SQL Server 2008 SQL Server 2008 - General decalre select RE: decalre select
HanShi
SSC-Dedicated
Points: 33506
More actions
July 15, 2013 at 1:04 am
#1632317
You need to apply the "N" when you set the value of the variable and not when you use the variable to fileter your results. This will work:
declare @kat nvarchar(50)
set @kat=N'M?nzild? qurum'
select * from kateqor where Name=@kat