Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql ²éѯ

  ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ

ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ-ÈÕ
Çó½Ì¸÷λ´óÏÀ
來點數據°É~~

ÓÃÏÈÅÐ斷λ數ÔÙÓÃsubstringÈ¡

15轉換18參ÕÕ


select * from view_MemberInfo where
(
case when len(f_CardID) = 15
then substring(f_CardID,9,4)
else substring(f_CardID,11,4)
end) between '1017' and '0420'
ÕâÑùд¶Ôô

ÒýÓÃ
ÓÃÏÈÅÐ斷λ數ÔÙÓÃsubstringÈ¡

15轉換18參ÕÕ


Ö§³Ö
{{


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

sql ʱ¼äÎÊÌâ

sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001

ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......

sql ÈçºÎ¼Ó±íµÄÅÅËûËø

ÒòΪÊǶà¿Í»§¶Ë²Ù×÷µÄ£¬ËùÒÔÏ£ÍûÔÚ¸üеÄʱºò£¬¿ÉÒ԰ѱíÓÃÅÅËûËøËø×¡£¬ÆäËûÓû§²»¿ÉÒÔ²éѯºÍÐÞ¸Ä

֮ǰ¿´µ½Ïà¹ØÎÊÌâÀïÃæÌáµ½ WITH  (XLOCK) £¬ÎÒÕâÀï¿ÉÒÔÓÃÕâ¸öÂð£¿

WITH  (XLOCK) ÓÃÍêÖ® ......

Çë¸ßÊÖ°ïÎÒдһÌõsqlÓï¾ä

ǰ¼¸Ìì¹«Ë¾ÃæÊÔ£¬¼ûµ½Ò»Ìâ,Çë¸ßÊÖ°ïÎÒ½â´ð£¬Ð»Ð»£¡

ÄÚÈÝtable:
id    name    parentid
1      aaa    null
14    bbb    1 ......

sql server 2005 µÄÖØÐ°²×°ÎÊÌâ

ÖØÐ°²×°sql server 2005ʱ£¬ÔÚ°²×°µ½ÀàËÆdata base service µÄ·þÎñʱ×ÜÊdzöÏîwindows installer µÄ´íÎó¡£
ÎÒÔÚÍøÉϲéÁ˽â¾öµÄ°ì·¨£¬ÏÈÍ£ÁËÕâ¸ö·þÎñ£¬È»ºóÖØÐÂÏÂÔØ°²×°ÁËInstMsiW.exe£¬È»ºóÓÖÆô¶¯Õâ¸ö·þÎñ£¬µ«ÊDz ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ