Showing posts with label anduse. Show all posts
Showing posts with label anduse. Show all posts

Monday, February 20, 2012

query syntax issue

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@.TK2MSFTNGP09.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 constant while N'Michl' is a Unicode constant. Unicode constants are interpreted as Unicode data, and are not evaluated using a code page. Unicode constants do have a collation, which primarily controls comparisons and case sensitivity. Unicode constants are assigned the default collation of the current database, 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 character 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@.TK2MSFTNGP09.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?

query syntax issue

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?