ÇóSQLÒ»ÌõÓï¾äµÄ½â¾ö·½·¨
±ÈÈç ÎÒÓÐÒ»¸ö±í bumen
ÀïÃæ ÓÐÒ»¸öÁÐ quanxian
id name quanxian
1 a 001;002;003;
2 b 002;003;
3 c 003;004;
4 d 001;002;003;
ÎÒµÄÒâ˼ÊÇ°ÑquanxianÁÐÖк¬ÓÐ002µÄÊý¾ÝÈ¡³öÀ´£»ÏÔʾÔÚgridviewÉÏ£¿
Çë´óÏÀÃÇ°ï棡
select * from tumen where quanxian like '%002%'
select * from tumen where quanxian like '%002%'
select * from tumen where charindex('002',quanxian) > 0
SQL code:
if object_id('ta') is not null drop table ta
go
create table ta(id int, name varchar(1), quanxian varchar(20))
insert into ta select
1, 'a', '001;002;003;' union all select
2, 'b', '002;003;' union all select
3, 'c', '003;004;' union all select
4, 'd', '001;002;003;'
select * from ta
where charindex(';002;',';'+quanxian)>0
id name quanxian
----------- ---- --------------------
1 a 001;002;003;
2 b 002;003;
4 d 001;002;003;
(3 ÐÐÊÜÓ°Ïì)
SQL code:
select * from tumen where charindex(','+'002'+',',','+quanxian+',') >
Ïà¹ØÎÊ´ð£º
ÓÐÁ½¸ö±í¡£·Ö±ð¶¼ÓÐIDÖ÷¼ü¡£A±íµÄIDºÍB±íµÄIDÊǶÔÓ¦µÄ£¬¾ÍÊÇA±í¼¸¸öID£¬B±í¾Í¼¸¸öID¡£A±íµÄIDÊÇʲô,B±íµÄID¾ÍÊÇʲô¡£
¿ÉÊÇÏÖÔÚA±íµÄID±ÈB±íµÄ¶àÁË¡£
ÎÒÏÖÔÚÏëÒª°ÑB±íÖÐÉٵIJ¿·Ö¸ø²¹ÆëÁË¡£Õâ¸ö²åÈëÓ¦¸ÃÔõôд ......
¿Í»§±í£º
¿Í»§±àºÅ ¿Í»§ÏúÊÛ×ܶî
aa 200
bb 300
cc ......
SQL code:
declare @cnt int
select @cnt=count(1) from TableTest
if(@cnt==0)
insert into TableTest values(1,'abc')
¶ÔÓÚÕâÑùµÄÒ»¶Îsql²¢·¢Ö´ÐÐʱ,Ó¦¸ÃÓпÉÄܲåÈëÖظ´¼Ç¼
²»ÖªµÀ´ó¼ÒÊÇÔõô· ......
ÓÐʱºòÔÚÊý¾ÝÖвéѯÊý¾ÝµÄʱºò¿¼ÂÇÐÔÄÜÎÊÌ⣬»á½«¸´ÔÓÓï¾ä²ð·Ö»ò½èÓÃÁÙʱ±íÀ´¶à´Î²éѯ×îÖյõ½ÏëÒªµÄÊý¾Ý£¬ÏÖÔÚ½«ÕâЩ²éѯÄÚÈÝ×ö³É±¨±í£¬ÐèҪд¸öÓï¾äÒ»ÆøºÇ³É¡£
ÎÒÏëÎʵÄSQLÊÇ·ñ¿ÉÒÔÔÚ²éѯÓï¾äÒ»½áÊøºó£¬ÔÙ×Ô¶¯Ô ......
×ÜÊý±í
×ֶΠnum,freq
numÊÇËùÊôÆÚµÄ×ÜÊý£¬freqÊǼǼ¸ÃÊýÖµËùÊôÄÄÒ»ÆÚµÄ
ÇøÓò±í
×ֶΠarea_name,tot,freq
ÇøÓòÃû³Æ£¬¸ÃÇøÓòµÄ×ÜÊý£¬ËùÊôÆÚ
Á½ÕÅ±í¿¿freq¹ØÁª£¬ÇÒ²»ÊÇ×ÔÔö×ֶΣ¬²»ÊÇÖ ......