What does N’ stands for in a SQL script ? (the one used before characters in insert script)

by

N is used to specify a unicode string.

Here’s a good discussion: Why do some SQL strings have an ‘N’ prefix?

In your example N prefix is not required because ASCII characters (with value less than 128) map directly to unicode. However, if you wanted to insert a name that was not ASCII then the N prefix would be required.

INSERT [dbo].[TableName] ([Sno], [Name], [EmployeeId], [ProjectId], [Experience]) 
VALUES (1, N'Wāhi', 'ESD157', 'FD080', 7)

More Related Contents:

  1. Unable to cast object of type ‘System.DBNull’ to type ‘System.String`
  2. Insert 2 million rows into SQL Server quickly
  3. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  4. How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?
  5. Populate TreeView from DataBase
  6. Databind a dropdownlist
  7. How To Access Two Databases in a Single connection String in C#?
  8. Calling async method synchronously
  9. Serializing a list to JSON
  10. CryptographicException: Padding is invalid and cannot be removed and Validation of viewstate MAC failed
  11. Are static methods thread safe
  12. prevent property from being serialized in web API
  13. Resizing an image in asp.net without losing the image quality
  14. ASP.NET MVC Global Variables
  15. Convert from binary data to an image control in ASP.NET
  16. Passing array of strings to webmethod with variable number of arguments using jQuery AJAX
  17. Getting relative virtual path from physical path
  18. Should I use byte or int?
  19. Order of execution with multiple filters in web api
  20. Windows Authentication and add Authorization Roles through database – MVC asp.net
  21. What is the best approach to handle session timeouts in asp.net
  22. Multiples Table in DataReader
  23. Redirect to another page when user is not authorized in asp.net mvc3
  24. Detect Browser Close on Asp.net
  25. Get the current user, within an ApiController action, without passing the userID as a parameter
  26. Multiple signalR connections/hubs on your website
  27. ASP.NET – AppDomain.CurrentDomain.GetAssemblies() – Assemblies missing after AppDomain restart
  28. WebAPI Request Streaming support
  29. Can I reuse HttpWebRequest without disconnecting from the server?
  30. Cast an Anonymous Types in Object and retrieve one Field

Leave a Comment