sqlÓï¾ä²éѯ
sqlÓï¾ä²éѯ
±í½á¹¹ÊÇÕâÑù£º
ID ÐÕÃû ÐÔ±ð
1 ÕÅÈý ÄÐ
2 ÍõËÄ ÄÐ
3 ÀöÀö Å®
4 ÕÅÈý ÄÐ
5 ÕÔÁø ÄÐ
6 ¸ß½à ÄÐ
7 ÍõËÄ Å®
8 ¸ß½à Å®
9 ÕÅÈý Å®
ÔõôÄÜÓÃÒ»ÌõSQLÓï¾ä²éѯ³öÈçϵĽá¹û
ÐÕÃû ÈËÔ±¸öÊý ÄÐÈËÊý Å®ÈËÊý °üº¬ID
ÕÅÈý 3 2 1 1£¬4£¬9
ÍõËÄ 2 1 1 2£¬7
ÀöÀö 1 0 1 3
¸ß½à 2 1 1 6£¬8
ÕÔÁø 1 1 0 5
SELECT * from (SELECT DISTINCT Name,Count(ID) as ÈË員個數,
sum(case when Sex='ÄÐ' then 1 else 0 end) as ÄÐÈË數,
sum(case when Sex='Å®' then 1 else 0 end) as Å®ÈË數
from Test group by Name) A
OUTER APPLY(
SELECT
[°üº¬ID]= STUFF(REPLACE(REPLACE(
(
SELECT ID from Test N
WHERE Name = A.Name
FOR XML AUTO
), '<N ID="', ','), '"/>', ''), 1, 1, '')
)N
Ïà¹ØÎĵµ£º
SQL ServerµÄ¸´ºÏË÷Òýѧϰ
¸ÅÒª
ʲôÊǵ¥Ò»Ë÷Òý,ʲôÓÖÊǸ´ºÏË÷ÒýÄØ? ºÎʱн¨¸´ºÏË÷Òý£¬¸´ºÏË÷ÒýÓÖÐèҪעÒâЩʲôÄØ£¿±¾ÆªÎÄÕÂÖ÷ÒªÊǶÔÍøÉÏһЩÌÖÂÛµÄ×ܽᡣ
Ò».¸ÅÄî
µ¥Ò»Ë÷ÒýÊÇÖ¸Ë÷ÒýÁÐΪһÁеÄÇé¿ö,¼´Ð½¨Ë÷ÒýµÄÓï¾äֻʵʩÔÚÒ»ÁÐÉÏ¡£
Óû§¿ÉÒÔÔÚ¶à¸öÁÐÉϽ¨Á¢Ë÷Òý£¬ÕâÖÖË÷Òý½Ð×ö¸´ºÏË÷Òý(×éºÏË÷Òý)¡£¸´ºÏË÷ÒýµÄ´´½¨· ......
±¾ÎĽ«½éÉÜC#ÏîÄ¿´ò°üÒÔ¼°×Ô¶¯°²×°SQL SeverÊý¾Ý¿â£¬°üÀ¨´´½¨²¿ÊðÏîÄ¿¡¢½«Ö÷³ÌÐòÏîÄ¿µÄÊä³öÌí¼Óµ½²¿ÊðÏîÄ¿ÖС¢´´½¨°²×°³ÌÐòÀà¡¢´´½¨×Ô¶¨Òå°²×°¶Ô»°¿òµÈµÈ¡£
’power by: landlordh
’for 2000,xp,2003
Module uninstall
Sub Main ......
SQL Server .NET Data Provider Á¬½Ó×Ö·û´®°üº¬Ò»¸öÓÉһЩÊôÐÔÃû/Öµ¶Ô×é³ÉµÄ¼¯ºÏ¡£Ã¿Ò»¸öÊôÐÔ/Öµ¶Ô¶¼ÓɷֺŸô¿ª¡£
PropertyName1=Value1;PropertyName2=Value2;PropertyName3=Value3;.....
ͬÑù£¬Á¬½Ó×Ö·û´®±ØÐë°üº¬SQL ServerʵÀýÃû³Æ:
  ......
Ò» µ¥´Ê½âÊÍ(2·Ö/¸ö) 34·Ö
¡¡¡¡Data Êý¾Ý Database Êý¾Ý¿â RDBMS ¹ØϵÊý¾Ý¿â¹ÜÀíϵͳ GRANT ÊÚȨ
¡¡¡¡REVOKE È¡ÏûȨÏÞ DENY ¾Ü¾øȨÏÞ DECLARE ¶¨Òå±äÁ¿ PROCEDURE´æ´¢¹ý³Ì
¡¡¡¡ÊÂÎñ Transaction ´¥·¢Æ÷ TRIGGER ¼ÌÐø continue Ψһ unqiue
¡¡¡¡Ö÷¼ü primary key ±êʶÁÐ identity Íâ¼ü foreign key ¼ì ......
Èç¹ûÏë²éÕÒ“_cs”½áβµÄµÄÕË»§
select * from [user] where loginname like '%_cs'ÊDz»Ðеģ¬_ ±»ÈÏΪÊÇÈÎÒâµÄ×Ö·û£¬
ËùÒÔÐèҪתÒå×Ö·û£¬ÓÐÁ½ÖÖд·¨£º
select * from [user] where loginname like '%[_]cs'
select * from [user] where loginname like '%/_cs' escape'/'
ͨÅä·ûº¬Òå
%
°üº¬Áã¸ö»ò¸ü¶à×Ö· ......