²©¿ÍµÇ¼
Óû§Ãû£º
ÃÜ¡¡Â룺
×¢²á
|
怬
Íü¼ÇÃÜÂ룿
51ctoÊ×Ò³
|
²©¿Í
|
ÂÛ̳
|
ÕÐÆ¸
ÈȵãÎÄÕÂ
°ÂÔË£¬Öйú½±ÅƵ½µ×Åŵڼ¸£¿
¡¡
°ïÖú
×ªÔØ
:15
·Òë
:0
Ô´´
:29
´óÎÀµÄÊý¾Ý¿âѧϰ²©¿Í
http://daiwei.blog.51cto.com
>
¸´ÖÆÁ´½Ó
ÑûÇë¼ÓÈë¼¼ÊõȦ
¼ÓÓÑÇéÁ´½Ó
·¢¶ÌÏûÏ¢
Ïà²á
¼¼ÊõȦ
²©¿Í
²©¿Í£º
ÎҵIJ©¿Í
|
·¢±íÎÄÕÂ
|
¹ÜÀí²©¿Í
|
Í˳ö
Ïà²á£º
ÎÒµÄÏà²á
|
ÉÏ´«Í¼Æ¬
|
×î½ü¸üÐÂÏà²á
¼¼ÊõȦ£º
´´½¨¼¼ÊõȦ
|
ÎÒ¼ÓÈëµÄȦ
|
ËÑË÷Ȧ
51ctoÊ×Ò³
²©¿ÍÊ×Ò³
¼¼ÊõÂÛ̳
ÕÐÆ¸ÆµµÀ
¡¡
Ê×Ò³
|
DBA³É³¤ÈÕ¼Ç
|
LINUXѧϰÈÕÖ¾
|
Èí¼þÓ¦ÓÃÆª
|
·Å·ÉÐÄÁé
daiwei18 µÄBLOG
²©¿Íͳ¼ÆÐÅÏ¢
Óû§Ãû£ºdaiwei18
ÎÄÕÂÊý£º44
ÆÀÂÛÊý£º18
·ÃÎÊÁ¿£º3916
ÎÞÓDZңº
1748
²©¿Í»ý·Ö£º
384
²©¿ÍµÈ¼¶£º
3
×¢²áÈÕÆÚ£º2006-11-06
×îÐÂÆÀÂÛ
137440593
£º
ѧУÏÞÖÆ,¿´²»µ½Í¼,°¥!!
[ÄäÃû]51ctoÓοͣº
ºÜºÃ£¡
[ÄäÃû]51ctoÓοͣº
ºÜºÃ£¡
С·ÏÎï
£º
ͬϲͬϲ£¬¼ÌÐøÁ·¼¶~~
Icansoft
£º
Ϊʲô3ºÍ4ûÓÐ˵Ã÷ËüÃǵÄÓŵãÄØ£¿
ÓÑÇéÁ´½Ó
ÐéÄâµÄÏÖʵ
˼Äî¹·µÄ¹ÇÍ·
Ï»×Ó
ÎÄÕÂ
ÎÄÕÂÁбí>>
SQLÒÉÄѽâÎö
2007-11-29 14:23:29
1
ÔÚsqlÓï¾äÖÐÈçºÎת»»Êý¾ÝÀàÐÍ
ÐèҪʹÓÃCAST»òÕßCONVERT
CAST(expression as data¡ªtype£©
CONVERT(data£type ¡¾£¨length¡¿£¬expression¡¾£¬style¡¿£©
expression£ºÊÇÈκÎÓÐЧµÄsql server2000±í´ïʽ
data£type£ºÄ¿±êϵͳËùÌṩµÄÊý¾ÝÀàÐÍ£¬°üÀ¨bigintºÍsql£variant£¬µ«²»ÄÜʹÓÃÓû§¶¨ÒåµÄÊý¾ÝÀàÐÍ
length£ºnchar¡¢nvarchar¡¢char¡¢varchar¡¢binaryºÍvarbinary½«Êý¾ÝÀàÐ͵ĿÉÑ¡²ÎÊý¡£
style£ºÈÕÆÚ¸ñʽÑùʽ£¬½«datetime»òsmalldatetimeÊý¾Ýת»»Îª×Ö·ûÊý¾Ý£¬»òÕß½«float¡¢real¡¢money»òsmallmoneyÊý¾ÝÀàÐÍת»»Îª×Ö·..
Àà±ð£ºDBA³É³¤ÈÕ¼Ç
|
ÔĶÁÈ«ÎÄ(44)
|
»Ø¸´(0)
Éè¼Æ¸ßЧµÄSQLÓï¾ä
2007-11-23 15:32:33
1
SET STATISTICS IO
²éѯSQLÓï¾äµÄ¶Áд´ú¼Û.
¿ÉÒÔÓÃÀ´²é¿´sqlÓï¾äµÄ¶ÁºÍдµÄ²Ù×÷µÄ´ú¼Û,¶ÔÍê³ÉͬÑù¹¦ÄܵÄÁ½¸ösqlÓï¾ä±È½Ï¶Áд´ú¼Û¾ÍÄܽøÐÐЧÂʵijõ²½±È½Ï°Â.
SET STATISTICS IO ON
GO
SELECT COUNT(*) FROM NORTHWIND..EMPLOYEES
GO
SET STATISTICS IO OFF
GO
2ͨ¹ýÖ´ÐÐϵͳ´æ´¢¹ý³ÌSP_SPACEUSED¿ÉÒԲ鿴±íµÄÎïÀí¿Õ¼ä
EXEC SP_SPACEUSED EMPLOYEES
3
SET STATISTICS TIME
²éѯSQLÓï¾äµÄÖ´ÐÐʱ¼ä
SET STATISTICS TIME ON
GO
SELECT COUNT(*) FROM NORTHWIND..EMPLOYEES
GO..
Àà±ð£ºDBA³É³¤ÈÕ¼Ç
|
ÔĶÁÈ«ÎÄ(107)
|
»Ø¸´(2)
<<
1
2
3
4
5
>>
Ò³Êý ( 1/10 )
51CTOÍÆ¼ö²©ÎÄ
¸ü¶à..
ÉÏÍøÎÞÓǵç×ÓÑÛ½«WebÍþв¾Ü..
»ùÓÚWebSphereÓëDominoµÄµç..
Active Diretory È«¹¥ÂÔ£¨..
linuxÍøÂçÅäÖᢲâÊÔ¼°¹ÊÕÏ..
¹ØÓÚServletÖеÄʼþ¼àÌý
JavaʵÏÖFTPÉÏ´«ÏÂÔØ¹¦ÄÜ
Ïê½âjavaÖеÄthis¹Ø¼ü×Ö
iBatis2ѧϰ±Ê¼Ç£ºÓëSpring..
IB¿Í×ùÖ÷±à(ËÄ)ÃÀ¹úÎ÷Ãɹ«..
×ß³öÈí¼þ×÷·»£ºÈýÎå¸öÈËÊ®..
½ÌÄã°ÑÎÕ°ÂÔËÉÌ»ú
SOAϵͳµÄ½¨Éè
°ÂÔË£¬Öйú½±ÅƵ½µ×Åŵڼ¸£¿
Æó¶ìÒ§ËÀɺº÷³æ£¬´°¿Ú¼ÐÀÃ..
ÎÒµÄIT֮·
°ÂÔ˽¡¶ùÃÇ ÓÀԶΪÄãÃǼÓÓÍ£¡
¹«¸æ
Ìì¸ßÈÎÄñ·É,º£À«Æ¾ÓãÔ¾¡£
ÈÈÃÅÎÄÕÂ
ÈçºÎ¶ÍÁ¶×Ô¼ºµÄÒâÖ¾ºÍÒãÁ¦
DBAµÄÖ°Ôð
Order By ºÍ Group By »¹..
LinuxÏÂoracle 9iͼÎݲװһ
DBAÈÕ³£¹¤×÷
¸ßÊÖ×î³£ÓõÄÎå¸ö¼üÅÌ×éºÏ¼ü
¶Ôµ±½ñÉç»áµÄijЩÏÖÏóµÄ¸ÐÏë
ɾ³ýÊý¾Ý¿âDrop Database
ËÑË÷BLOGÎÄÕÂ
51CTOÍÆ¼ö²©¿Í
DZÁú
cince
coinking
struggle1=1
cownew
javafans8171
dufei
david_yeung
piluge
±±¾©¿´¿´
mk6yeung
ÖìÂÉçâ