m****e
发帖数: 1197 | 1 在有些SQL SERVER上NOLOCK是蓝色的，就像SELECT等等这种RESERVED WORD。有些
SERVER上TYPE OUT以后不会变成蓝色的。请问这是为什么？不会变蓝的SERVER上，
NOLOCK是不是不起作用的就算我加了？ |
i****a
发帖数: 36252 | 2 from the same workstation client or are you using the client on different
machines? |
m****e
发帖数: 1197 | 3 i am using a clinet different from the server.
is this a setting issue? how can I reset it?
【在 i****a 的大作中提到】
: from the same workstation client or are you using the client on different
: machines?
|
i****a
发帖数: 36252 | 4 try to go Tools -> Options
Environment -> Fonts and Colors and click "Use defaults"
but in any case, the color on your sql query has no effect on the execution |
m****e
发帖数: 1197 | 5 it's all default. and i reset it again.
my co-work's client is blue on NOLOCK, why mine is different? any clue?
execution
【在 i****a 的大作中提到】
: try to go Tools -> Options
: Environment -> Fonts and Colors and click "Use defaults"
: but in any case, the color on your sql query has no effect on the execution
|
i****a
发帖数: 36252 | 6 are you on SQL management studio 2008?
in fonts and colors again, select "Keyword" in the "Display items:" box.
does it have blue color as foreground color? |
m****e
发帖数: 1197 | 7 yes, it was set to default, blue.
i even tried customizing it to red, it applies to other keywords like SELECT
, etc, but nothing happened to NOLOCK.
it looks to me NOLOCK is not set as "reserved keywords" on this server. is
it possible? this setting comes from Mircorsoft or something can be altered
by DBA?
【在 i****a 的大作中提到】
: are you on SQL management studio 2008?
: in fonts and colors again, select "Keyword" in the "Display items:" box.
: does it have blue color as foreground color?
|
i****a
发帖数: 36252 | 8 again, color and font is on the client only, server has nothing to do with
it.
SELECT
is
altered
【在 m****e 的大作中提到】
: yes, it was set to default, blue.
: i even tried customizing it to red, it applies to other keywords like SELECT
: , etc, but nothing happened to NOLOCK.
: it looks to me NOLOCK is not set as "reserved keywords" on this server. is
: it possible? this setting comes from Mircorsoft or something can be altered
: by DBA?
|
