Unanswered: Stored Procedure with 'N' and variable
I need to compare words with eachother, but the words can also be a sign (japanese, chinese, etc)
I use NVarChar. Below is the code i use to compare them (Stored Procedure):
CREATE PROCEDURE sp_selectLanguage
SELECT Language_ID FROM Languages WHERE Language_Name = @Language_Name
eg. @Language_Name is English, it works, but not with a sign. Therefor u need this:
... WHERE Language_Name = N'here comes the variable'
But how can I code this?
Not by this: WHERE Language_Name = N @Language_Name