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

Post

View All

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

0
2.1k
1

Post Your Answer

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