SET @cmd = N'DELETE FROM ' + @table_name + ' WHERE ' + @nameField +' = ''' + @value +''' ' in above statement what is the use of N
Yogesh Bajpai
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)