Redian新闻
>
NOLOCK为什么不是蓝色的?
avatar
m*e
2
在有些SQL SERVER上NOLOCK是蓝色的,就像SELECT等等这种RESERVED WORD。有些
SERVER上TYPE OUT以后不会变成蓝色的。请问这是为什么?不会变蓝的SERVER上,
NOLOCK是不是不起作用的就算我加了?
avatar
s*l
3
我贴一个千与千寻,最喜欢千寻坐火车去找钱婆婆的那一段,在清澈的海水里行驶的火
车,驶向一个未知的远方,我也想坐一次这样的火车,呵呵。
http://www.youtube.com/watch?v=QCXVlyX5yTs

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

avatar
i*a
4
from the same workstation client or are you using the client on different
machines?
avatar
T*r
5
真好,宫崎骏的两大制作(也是我最喜欢的两部)都在这个帖子里面了。数不尽的梦幻
,very fanciful :-)

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

avatar
m*e
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?

avatar
s*l
7
∩_∩

【在 T**r 的大作中提到】
: 真好,宫崎骏的两大制作(也是我最喜欢的两部)都在这个帖子里面了。数不尽的梦幻
: ,very fanciful :-)

avatar
i*a
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
avatar
c*o
9
我也最喜欢在水里的火车那段音乐,叫做the sixth station。不过你贴的这段youtube
不是这个音乐啊。

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

avatar
m*e
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

avatar
c*o
11
should be this one:
http://www.youtube.com/watch?v=vkHi5vmXCi8

youtube

【在 c*****o 的大作中提到】
: 我也最喜欢在水里的火车那段音乐,叫做the sixth station。不过你贴的这段youtube
: 不是这个音乐啊。

avatar
i*a
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?
avatar
T*r
13
多谢分享。两个音乐都不错^-^
画面尤其精美
再贴个久石让的《天空之城》的音乐

【在 c*****o 的大作中提到】
: should be this one:
: http://www.youtube.com/watch?v=vkHi5vmXCi8
:
: youtube

avatar
m*e
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?

avatar
i*a
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?

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。