How to create stored procedure to insert nvarchar data type?

Dec 1 2011 4:50 AM

Hello friends!
I want to insert nvarchar data type through Storedprocedure such as hindi,chiniese etc.
For example:
Insert into Users(Test)Values(N'some charactors'). This query is working fine but I am unable to do this through stored procedure.