sqlserver ×Ô¶¨Ò庯Êýreturn ÎÊÌâ
SQL code:
create function subDepartment(@id varchar(36),@flag int)
returns @re table(subid varchar(36))
as
begin
insert @re select deli_id from departmentlink where deli_type=32
and deli_id =@id
if @flag=0
return
while @@rowcount>0
begin
insert @re
select a.deli_id from departmentlink a ,@re b
where a.deli_type=32 and a.deli_depa_id =b.subid
and a.deli_id not in (select subid from @re)
end
return
end
º¯ÊýµÄ×÷ÓÃÊÇ´´½¨ÕÒ³öÒ»¸öµ¥Î»µÄËùÓÐϼ¶µ¥Î»»òÕß¾ÍÕÒ³ö±¾µ¥Î»¡£
µÚÒ»¸ö²ÎÊý±íʾ£¬Éϼ¶ID£¬¸ù¾ÝËûÕÒ³öËûÏÂÃæµÄËùÓÐϼ¶ID,
µÚ¶þ¸ö²ÎÊý±íʾ£¬ÊÇÒ»¸ö±ê¼Ç£¬Èç¹ûÊÇ0¾Í±íʾֻ·µ»Ø±¾Éí£¬Èç¹ûÊÇ·Ç0 ¾ÍÖ´ÐÐÕÒϼ¶µÄ´úÂë¡£¡£
µ«ÊDz»¹ÜÎÒÊÇ
select * from subDepartment('56B4217998F243BA8EF2ABC456C8D3A1',0)
select * from subDepartment('56B4217998F243BA8EF2ABC456C8D3A1',999)
·µ»ØµÄ½á¹û¶¼ÊÇÒ»ÌõÊý¾Ý¡£¡£Ò²¾Í±íʾ²»¹Üflag±äÁ¿ÊÇ£¬0 »¹ÊÇ999¶¼@flag=0¶¼ÊÇÕæ¡£¡£¡£¡£¸ßÊÖ°ïæ°¡
ÄãµÄWHEREµÄÖÕÖ¹Ìõ¼þÄØ£¿Ã¿´ÎÑ»·¶¼Ã»±ä»¯°É
ÎÒÒÔǰдµÄÒ»¸öСÀý×Ó£¬·¢ÉÏÀ´¹©Äã²Î¿¼
SQL code:
if not object_id('tb') is null drop table tb
IF OBJECT_ID('FUN_MU
Ïà¹ØÎÊ´ð£º
ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍÆ¼öÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾
ʲôÐÐÒµ°¡....
µ½51aspx.co ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ
ûÕâ¸ö˵·¨.
Ö»¸øSELECT ,
UPDATEµÄÖ»¸øÄ³Ð©±í
¸ö²»»á
µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã
Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......
ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......
conn.execute "delete from PSTC_About where id in ("&SelectID&")"
ÆäÖÐSelectIDÊÇ´«µÝ¹ýÀ´µÄ¼Ç¼ID£¬Êµ¼ÊÐγɵÄÓï¾äÈç conn.execute "delete from PSTC_About where id in ( ......