NOLOCK为什么不是蓝色的？ - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

NOLOCK为什么不是蓝色的？

NOLOCK为什么不是蓝色的？# Database - 数据库

T*r2010-03-08 08:03

1 楼

m*e2010-03-08 08:03

2 楼

在有些SQL SERVER上NOLOCK是蓝色的，就像SELECT等等这种RESERVED WORD。有些
SERVER上TYPE OUT以后不会变成蓝色的。请问这是为什么？不会变蓝的SERVER上，
NOLOCK是不是不起作用的就算我加了？

s*l2010-03-08 08:03

3 楼

我贴一个千与千寻，最喜欢千寻坐火车去找钱婆婆的那一段，在清澈的海水里行驶的火
车，驶向一个未知的远方，我也想坐一次这样的火车，呵呵。
http://www.youtube.com/watch?v=QCXVlyX5yTs

【在 T**r 的大作中提到】

i*a2010-03-08 08:03

4 楼

from the same workstation client or are you using the client on different
machines?

T*r2010-03-08 08:03

5 楼

真好，宫崎骏的两大制作（也是我最喜欢的两部）都在这个帖子里面了。数不尽的梦幻
，very fanciful :-)

【在 s******l 的大作中提到】

: 我贴一个千与千寻，最喜欢千寻坐火车去找钱婆婆的那一段，在清澈的海水里行驶的火
: 车，驶向一个未知的远方，我也想坐一次这样的火车，呵呵。
: http://www.youtube.com/watch?v=QCXVlyX5yTs

m*e2010-03-08 08:03

6 楼

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?

s*l2010-03-08 08:03

7 楼

∩_∩

【在 T**r 的大作中提到】

: 真好，宫崎骏的两大制作（也是我最喜欢的两部）都在这个帖子里面了。数不尽的梦幻
: ，very fanciful :-)

i*a2010-03-08 08:03

8 楼

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

c*o2010-03-08 08:03

9 楼

我也最喜欢在水里的火车那段音乐，叫做the sixth station。不过你贴的这段youtube
不是这个音乐啊。

【在 s******l 的大作中提到】

m*e2010-03-08 08:03

10 楼

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

c*o2010-03-08 08:03

11 楼

should be this one:
http://www.youtube.com/watch?v=vkHi5vmXCi8

youtube

【在 c*****o 的大作中提到】

: 我也最喜欢在水里的火车那段音乐，叫做the sixth station。不过你贴的这段youtube
: 不是这个音乐啊。

i*a2010-03-08 08:03

12 楼

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?

T*r2010-03-08 08:03

13 楼

多谢分享。两个音乐都不错^-^
画面尤其精美
再贴个久石让的《天空之城》的音乐

【在 c*****o 的大作中提到】

: should be this one:
: http://www.youtube.com/watch?v=vkHi5vmXCi8
:
: youtube

m*e2010-03-08 08:03

14 楼

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*a2010-03-08 08:03

15 楼

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?