Yogesh Bajpai
SET @cmd = N'DELETE FROM ' + @table_name + ' WHERE ' + @nameField +' = ''' + @value +''' ' in above statement what is the use of N
By Yogesh Bajpai in SQL Server on Apr 25 2012
  • anjnesh yadav
    Apr, 2013 4

    You may have seen Transact-SQL code that passes strings around using an N prefix. This denotes that the subsequent string is in Unicode (the N actually stands for National language character set). Which means that you are passing an NCHAR, NVARCHAR or NTEXT value, as opposed to CHAR, VARCHAR or TEXT. Anjnesh Yadav(SE)

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS