what does the "n'dbname" what does the 'n' stand for and
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"
"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