1
Reply

SET @cmd = N'DELETE FROM ' + @table_name + ' WHERE ' + @nameField +' = ''' + @value +''' ' in above statement what is the use of N

Yogesh Bajpai

Yogesh Bajpai
13y
1.6k
0
Reply
    anjnesh yadav
    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)
    anjnesh yadav
    12y
    0
Message