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

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


Ïà¹ØÎÊ´ð£º

ÇóÒ»ÐÐÒµÍøÔ´Âë(C#+sqlserver)

ÈçÌâ
Ö»ÓÐ100·Ö¸øÁË¡£¡£¡£
ÄĸöÐÐÒµ£¿
ÎÒÏëÍøÉϵÄÔ´Âë¿Ï¶¨²»ÄÜÍêÈ«Âú×ã¸öÈËÏë·¨
×îºó»¹µÃ×Ô¼ºÕû
ÍÆ¼öÒ»¿î×ÔÖú½¨Õ¾Èí¼þ£º·çѶ
C#+SQL
¿ÉÒÔÉè¼Æ³ö±È½ÏÁé»îµÄÍøÕ¾

ʲôÐÐÒµ°¡....

µ½51aspx.co ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sqlserver¶Ôij¸ö±í²Ù×÷¼Ó¸öÓû§

sqlserver,Èç¹û¼Ó¸öÓû§,ȨÏÞÊǶÁËùÓÐ±í£¬µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ
ûÕâ¸ö˵·¨.

Ö»¸øSELECT ,

UPDATEµÄÖ»¸øÄ³Ð©±í

¸ö²»»á

µ«Ö»ÄÜÐÞ¸Äij¸ö±íµÄ×Ö¶ÎÊôÐÔ Õâ¸öÄѸã

Òª¼ÓȨÏÞµÃÕë¶Ôij¸öÊý¾Ý¿â
......

ÈçºÎÉèÖÃSqlserverÊý¾Ý¿âÈÕÖ¾Ôö³¤·½Ê½

ÈçÌâ¡£
ÎÒÏ붨ÆÚÖ´ÐгÌÐò£¬É¾³ý²»ÓõÄÊý¾Ý£¬ÊÕËõÒ»ÏÂÊý¾Ý¿â£¬Æ½Ê±Ê¹ÓõÄʱºò£¬ÈÕÖ¾×î´óÎļþ´óСΪÏÞÖÆ200MB£¬
µ«ÊÇÊÕËõµÄʱºò£¬»á²úÉú´óÁ¿ÈÕÖ¾£¬Èç¹û³¬¹ýÏÞÖÆ£¬ÔòÊÕËõÊý¾Ý¿âʱ»áʧ°Ü£¬ÎÒÏë¸ÄΪ×î´óÎļþ´óС²»Ê ......

asp SqlServerÎÞ·¨É¾³ý

conn.execute "delete from PSTC_About where id in ("&SelectID&")"
ÆäÖÐSelectIDÊÇ´«µÝ¹ýÀ´µÄ¼Ç¼ID£¬Êµ¼ÊÐγɵÄÓï¾äÈç conn.execute "delete from PSTC_About where id in ( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ