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

Sql server Case when

select
 WorksheetID,worker,WorkDate,merchantName ,merchantNo ,manager
, case when insCount>0 then 'ÐÂ×°' else '' end InsStr
,case when repCount>0 then '»»×°' else '' end RepStr
,case when UnInsCount>0 then '³·»ú' else '' end UnInsStr
,case when FaultCount>0 then '¹ÊÕÏ´¦Àí' else '' end FaultStr
,case when VisitCount>0 then 'Ѳ¼ì' else '' end VisitStr 
,case when SendConsumableCount>0 then 'ºÄ²ÄÅäËÍ' else '' end SendConsumableStr 
,case when SoftUpdateCount>0 then '³ÌÐòÉý¼¶' else '' end SoftUpdateStr 
,case when  takeSheetCount>0 then 'È¡Ë͵¥¾Ý' else '' end  takeSheetStr 
from MaintainInfo_ReadyForData;


Ïà¹ØÎĵµ£º

SQLÂÒÂëµÄÎÊÌâ

ÔÚSQL   Server   Unicode×Ö·û´®³£Á¿ÐèҪǰ׺N  
   
  µ±ÔÚSQL  
SERVERÀï±ß´¦Àí×Ö·û´®³£Á¿µÄʱºòÄã±ØÐëÔÚ³£Á¿Ö®Ç°·ÅÒ»¸ö´óдµÄN,¾ÍÏñSQL  
SERVERÁ¬»úÎĵµ±êÌâΪ"²ÉÓÃUnicodeÊý¾Ý"Ëù˵Ã÷µÄÄÇÑù.Nǰ׺ÏóÕ÷×ÅÔÚSQL-92  
±ê×¼µÄ¹ú¼ÒÓïÑÔ,²¢ÇÒ±ØÐëÊÇ´óд×Öĸ.Èç¹ûÄãÔ ......

"SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø "

"SQL   Server   ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø "
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔ­Òò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à.
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ:
1,SQL   ServerÃû³Æ»òIPµØÖ·Æ´Ð´ÓÐÎó
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑ­ÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµÄÔ­Òò.
= ......

SQL Server ÈÕÆÚºÍʱ¼äº¯Êý


 
1¡¢³£ÓÃÈÕÆÚ·½·¨(ÏÂÃæµÄGetDate() = '2006-11-08 13:37:56.233')
(1)DATENAME ( datepart ,date )
   ·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®¡£DatepartÏê¼ûÏÂÃæµÄÁбí.
SELECT DateName(day,Getdate()) –·µ»Ø8
(2)DATEPART ( datepart , date )
    ·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸ ......

¸ßÈËÇóÖú£¬SQLÎÊÌ⣡

ԭʼÊý¾Ý
 
  
TERMINAL_ID
MAXDATE
TERMINAL_ID
OCCUR_DATE_TIME
TROUBLE_CD
  
1
12345
20100401102754
12345
20100401102754
210
  
2
12345
20100401102754
12345
20100401102754
211
  
3
12345
20100401102754
12345
20100401102754
?09
......

SQL SERVER 2005ÎÞ·¨Ô¶³ÌÁ¬½ÓµÄÎÊÌâ

Á¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü (Microsoft SQL Server£¬´íÎó: 10060)
×ʼÄãµÃÈ·¶¨¿Í»§¶ËÊÇ·ñÄÜpingͨ·þÎñÆ÷¶ËµÄipµØÖ·£¬Èç¹û²»ÄÜÔòÇëÐ޸ķþÎñÆ÷¶ËµÄ·À»ðǽµÄÏàÓ¦¹æÔò£¬Ê¹µÃ¿Í»§¶ËÄܹ»pingÈ룬Ȼºó¾Í¿ªÊ¼½øÐÐÏÂÃæµÄ²½Öè¡£
²½Öè1.
´ò¿ªSQL Server Configur ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ