title: stored procedure to support unicode characters
body: <p>i have this stored procedure </p>
  
  <pre><code>ALTER PROC [Resource_Control].[sp_LocationsInsert] 
  @name nvarchar(100) = NULL,
  @address nvarchar(500) = NULL
  AS 
  
  SET NOCOUNT ON 
  SET XACT_ABORT ON  
  
  BEGIN TRAN
  
  INSERT INTO [Resource_Control].[Location] ([name], [address])
  SELECT N'@name', N'@address'
  
  COMMIT
  </code></pre>
  
  <p>name and address column are both nvarchar
  do i need N before my parameters ?
  and if so did i put them in right place ?</p>