Home / server / Questions / 201504
Accepted
user48642
Asked: 2010-11-14 07:51:57 +0800 CST

what does the "n'dbname" what does the 'n' stand for and

  • 772
USE [master] 
GO 
/****** Object:  Database [assist]    Script Date: 11/13/2010 20:17:49 ******/
CREATE DATABASE [assist] ON  PRIMARY 
( NAME = N'assist', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.THIRD\MSSQL\DATA\assist.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'assist_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.THIRD\MSSQL\DATA\assist_log.LDF' , SIZE = 504KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

In the above, what do the following terms mean/usage.

  • GO?

  • N' within this statement "NAME = N'assist', FILENAME = N'C:\Program Files"

sql-server scripting sql

1 Answers

  1. Best Answer

    "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. See Article #2354 for a comparison of these data types. "

    reference from aspfaq.com

    • 9