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

¹ØÓÚSQL²éѯµÄÇë½Ì - MS-SQL Server / Ó¦ÓÃʵÀý

ÔÚÒ»¸öSQL SERVER 2005µÄÊý¾Ý¿âDANJUÄÚÓÐÈý¸ö±í£º
Containers£¨¼¯×°Ï䱨¼ìµ¥£©£¬Guangdong£¨¹ã¶«·¢Æ±£©£¬Shenzhen£¨ÉîÛÚ·¢Æ±£©¡£
Èý¸ö±íÖ®¼äûÓÐÁªÏµ£¬·Ö±ð°üº¬ÒÔÏÂ×ֶΣº
Containers£º±àºÅ¡¢±¨¼ìµ¥Î»¡¢±¨¼ìÈÕÆÚ¡¢½ø³ö¿ÚÀàÐÍ£¨½ø¿Ú¡¢³ö¿Ú£©¡£
Guangdong£º±àºÅ¡¢Ïú»õµ¥Î»¡¢¿ªÆ±ÈÕÆÚ¡¢ÒµÎñÀàÐÍ£¨±¾²¿¡¢ÍâÀ´£©¡£
Shenzhen£º±àºÅ¡¢Ïú»õµ¥Î»¡¢¿ªÆ±ÈÕÆÚ¡¢ÒµÎñÀàÐÍ£¨±¾²¿¡¢ÍâÀ´£©¡£
ÏÖÔÚÒª³öÈçϸñʽµÄ±¨±í£¨Ê±¼ä¶Î£©£¬ÇëÎÊÓ¦¸ÃÔõÑùдSQL£¿·Ç³£¸Ðл£¡

»¹Óкϲ¢ÁÐÍ·µÄ¹¦ÄÜ£¬Õâ¸öÎÒÃÇÓÃc#×÷£¬¶¼ÒªºÜÂé·³

實際¿´²»µ½ÄãÈý個±íµÄ關ϵ£¬Èç¹ûÕÕ這樣¿´£¬關聯應該ÊÇ ±àºÅ¡¢±¨¼ìµ¥Î»¡¢±¨¼ìÈÕÆÚ 這Èý個»òÕß ±¨¼ìµ¥Î»¡¢±¨¼ìÈÕÆÚ 這兩個£¬¾ß體Äã¿ÉÒÔ¿´ÏÂÊÇʲ麼關聯×ö調Õû紅É«²¿·ÖµÄ條¼þ£¬¿ÉÒÔ這樣寫

SElect A.±¨¼ìÈÕÆÚ,count(case when ½ø³ö¿ÚÀàÐÍ='½ø¿Ú' then 1 else 0 end),ÆäËü欄λҲÈç´ËµÀÀí
from Containers A
Join Guangdong B On A.±¨¼ìµ¥Î»=B.Ïú»õµ¥Î» And A.±¨¼ìÈÕÆÚ=B.¿ªÆ±ÈÕÆÚJoin Shenzhen C On A.±¨¼ìµ¥Î»=C.Ïú»õµ¥Î» And A.±¨¼ìÈÕÆÚ=C.¿ªÆ±ÈÕÆÚ
Group by A.±¨¼ìÈÕÆÚ


Õâ¸öÓ¦¸ÃÊÇÓÃT-SQLÀ´ÊµÏÖ°É£¿ÎÒ×Ô¼ºÕâÑùд´æ´¢¹ý³Ì£º
SQL code:

use danju
go
create procedure MonthlyReport
@date1 smalldatetime,
@date2 smalldatetime
as
begin
select
(select count(*) from containers where ½ø³ö¿ÚÀàÐÍ='½ø¿Ú'


Ïà¹ØÎÊ´ð£º

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

Çë½ÌSQLSERVERµÄÁ½¸öÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......

Çóһʱ¼ä±È½ÏµÄSQL Ö¸Áî - MS-SQL Server / »ù´¡Àà

±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ