What is the difference between
use [aes50] DBCC SHRINKFILE (N'aes50_Log', TRUNCATEONLY)
And
use [aes50] DBCC SHRINKFILE ('aes50_Log', TRUNCATEONLY)
What does the N represent?UNICODE
"Mark" <mark_kurten@.acordia.com> wrote in message news:O7voP$dIGHA.3492@.TK2M
SFTNGP09.phx.gbl...
What is the difference between
use [aes50] DBCC SHRINKFILE (N'aes50_Log', TRUNCATEONLY)
And
use [aes50] DBCC SHRINKFILE ('aes50_Log', TRUNCATEONLY)
What does the N represent?|||From BOL
Unicode strings
Unicode strings have a format similar to character strings but are preceded
by an N identifier (N stands for National Language in the SQL-92 standard).
The N prefix must be uppercase. For example, 'Michl' is a character constan
t while N'Michl' is a Unicode constant. Unicode constants are interpreted a
s Unicode data, and are not evaluated using a code page. Unicode constants d
o have a collation, which primarily controls comparisons and case sensitivit
y. Unicode constants are assigned the default collation of the current datab
ase, unless the COLLATE clause is used to specify a collation. Unicode data
is stored using two bytes per character, as opposed to one byte per characte
r for character data. For more information, see Using Unicode Data.
Unicode string constants support enhanced collations.
"Mark" <mark_kurten@.acordia.com> wrote in message news:O7voP$dIGHA.3492@.TK2M
SFTNGP09.phx.gbl...
What is the difference between
use [aes50] DBCC SHRINKFILE (N'aes50_Log', TRUNCATEONLY)
And
use [aes50] DBCC SHRINKFILE ('aes50_Log', TRUNCATEONLY)
What does the N represent?
Monday, February 20, 2012
query syntax issue
Labels:
91aes50,
aes50_log,
anduse,
betweenuse,
database,
dbcc,
microsoft,
mysql,
oracle,
query,
server,
shrinkfile,
sql,
syntax,
truncateonly
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment