June 23, 2005 at 1:08 am
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Community')
DROP DATABASE [Community]
GO
CREATE DATABASE [Community] ON (NAME = N'community_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\community_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'community_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\community_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
GO
exec sp_dboption N'Community', N'autoclose', N'false'
GO
there is a N in the back of NAME, FILENAME and exec sp_dboption, I can not
understand why writing in this way , what is the meaning of N ? can you help
me ? thanks you so much
June 23, 2005 at 1:41 am
N denotes that the following string is a unicode string.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 24, 2005 at 9:59 pm
Frank Kalis
THANK YOU SO MUCH FOR YOUR ANSWER ! THANK YOU AGAIN!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply