I have a stored procedure:
CREATE PROCEDURE Product_Info @name nvarchar(40) AS SELECT * FROM Product p WHERE p.Name LIKE @name;
I know that if I want to pass a Unicode parameter, I can run this statement EXECUTE Product_Info @name = N'ChineseCharacter'
I am writing a CSharp .NET application to call the Stored Procedure. How can I pass the Chinese (Unicode) character as the parameter, without running the Execute statement ?