Passing N prefix to stored procedure variable
Posted on 2009-04-16
In a table I have a column to hold kpi names in czech language. Column type is nvarchar.
Below sp will query the table to get kpi id.
ALTER PROC [dbo].[USP_GetKPiValue]
SELECT KPI_ID from dbo.tblKPI where KPI_DisplayText = @SKPI_DisplayText or KPI_Name_Czech = @SKPI_DisplayText
But this query is not responding as expected. if I run the query with direct value like below, it works.
SELECT KPI_ID FROM dbo.tblKPI where KPI_Name_Czech = N'Nevyu~itý as'
Can anybody give me a solution to add 'N' to the stored procedure variable?