SQLÎÞÏÞ·Ö¼¶½á¹¹
×î½ü£¬ÒòΪÏîÄ¿µÄÔÒò£¬ÐèÒªÉè¼ÆÒ»¸öÊý¾Ý¿â£¬¸ÃÊý¾Ý¿âµÄ¹¦ÄÜÖ÷ÒªÊÇÃèÊöÎļþϵͳµÄ½á¹¹ºÍÎļþÐÅÏ¢£¬ÔÚÍøÉÏÕÒÁ˺ܶàµÄ×ÊÁÏ£¬µ«ÊÇÐí¶àÉè¼ÆҪôÕë¶Ô²éѯÁ¿±È½Ï¶àµÄÀ´×ö£¬ÒªÃ´Õë¶ÔÐ޸ġ¢²åÈëÁ¿±È½Ï¶àµÄÀ´×ö£¬¶ø¶ÔÓÚÎļþϵͳ¶øÑÔ£¬ËüµÄ²éѯ¡¢²åÈë¡¢Ð޸Ķ¼ÊÇÏ൱Ƶ·±µÄ£¬Òò´Ë£¬Êý¾Ý¿âµÄÉè¼Æ¼«ÆäÖØÒª,ÏÖ½«×Ô¼ºµÄÒ»µãÏ뷨˵˵£¬Ï£Íû´ó¼ÒÄܹ»¸øÒ»µãÒâ¼û°¡£¡£¡
Ò»¿ªÊ¼£¬ÎªÁ˾¡¿ìÀ³öÔÐÍϵͳ£¬ÎÒ²ÉÓÃÁËname£¨±¾½áµã£©£¬parent£¨¸¸½Úµã£©£¬ancestor£¨×æÏȽáµã£© À´ÃèÊöÆä½á¹¹£¬È»ºó²ÉÓõݹéË㷨ȥ¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÕâÑù£¬¹¦ÄÜ»ù±¾¿ÉÒÔÍê³É£¬µ«ÊÇ£¬ÊµÔÚµ£ÐÄÔÚÎļþ¼ÐÉî¶È¹ý¸ßʱÊý¾Ý¿â³ÐÊܲ»ÁËÕâÑùµÄ¸ºµ££¬ÓÚÊÇ£¬ÔÚÑ°ÕÒ½â¾ö°ì·¨¡£
µÚÒ»ÖÖ·½·¨£¬¸Ä½øSQLÓï¾äÂß¼£ºÕâÖÖ·½·¨¶ÔÓÚÏÖÓÐÊý¾Ý¿âÉè¼ÆºÍ³ÌÐòÉè¼Æ¶øÑÔ£¬Ó¦¸Ã˵ÓÅ»¯¹¤×÷Á¿ÊÇ×îСµÄ£¬µ«ÊÇ£¬±¾ÈË»¹Ã»ÓвâÊÔ¹ý²»ÖªÊÇ·ñ¿ÉÐУ¬ÏÈд³öÀ´£¬ÕûÀí˼·£º
ͨ¹ýϵͳ¹¦ÄܺÍÊý¾Ý¿â½á¹¹µÄ·ÖÎö£¬¹¦ÄܲÙ×÷ÎÞ·ÇÊǶÔÎļþ¸´ÖÆ¡¢Òƶ¯¡¢É¾³ý¡¢Ð½¨µÈ£¬¶øÕâЩ¹¦ÄܵÄÖ÷ÒªÎÊÌâÊǶÔÎļþ¼Ð½øÐÐÀàËƲÙ×÷ʱ£¬ÔõÑùͬʱÐÞ¸ÄÆä×ÓËï½áµãµÄÏà¹ØÐÅÏ¢£¬ÕâÒ²ÊÇÎҵݹéµÄÔÒò¡£ºó×Ðϸ¹Û²ìÊý¾Ý¿âµÄÊý¾Ý·¢ÏÖ²éѯ½áµãµÄ×ÓËï½áµãÖ»Òª¶ÔSQL½øÐиĽøËƺõ¾Í¿ÉÒÔ°ìµ½£º
$rs=mysql_query(select ancestor from info where name=$id);(²éѯҪ²Ù×÷½áµãµÄ×æÏȽáµã)£»
$ancestor.=$rs[0]['ancestor'].":".$id;
$rs1=mysql_query(select name from info where ancestor like $ancestor%);
¶÷£¬ÕâÑùµÄ²Ù×÷Ëƺõ¿ÉÒÔÍê³É¶Ô×ÓËï½áµãµÄ»ñÈ¡£¬¶ø²»ÓñéÀú¡£¾ßÌåµÄЧ¹û£¬´ýÎÒ²âÊÔºóÔÙÌù°É¡£
µÚ¶þÖÖ·½·¨£¬ÊDZȽÏÕë¶ÔÓÚ²éѯ½Ï¶àÐ޸ĽÏÉÙµÄÊý¾Ý¿âÉè¼Æ£¬¸öÈ˾õµÃ²»Ì«ÊʺÏÏÖÓÐÕâ¸öÏîÄ¿£¬µ«ÊÇ˼·ºÍ·½·¨ÐԱȽϺã¬Ò²Ìù³öÀ´°É¡££¨×ªÔØ£©
²úÆ··ÖÀ࣬¶à¼¶µÄÊ÷×´½á¹¹µÄÂÛ̳£¬ÓʼþÁбíµÈÐí¶àµØ·½ÎÒÃǶ¼»áÓöµ½ÕâÑùµÄÎÊÌ⣺ÈçºÎ´æ´¢¶à¼¶½á¹¹µÄÊý¾Ý£¿ÔÚPHPµÄÓ¦ÓÃÖУ¬Ìṩºǫ́Êý¾Ý´æ´¢µÄͨ³£ÊǹØϵÐÍÊý¾Ý¿â£¬ËüÄܹ»±£´æ´óÁ¿µÄÊý¾Ý£¬Ìṩ¸ßЧµÄÊý¾Ý¼ìË÷ºÍ¸üзþÎñ¡£È»¶ø¹ØϵÐÍÊý¾ÝµÄ»ù±¾ÐÎʽÊÇ×ݺύ´íµÄ±í£¬ÊÇÒ»¸öƽÃæµÄ½á¹¹£¬Èç¹ûÒª½«¶à¼¶Ê÷×´½á¹¹´æ´¢ÔÚ¹ØϵÐÍÊý¾Ý¿âÀï¾ÍÐèÒª½øÐкÏÀíµÄ·Ò빤×÷¡£½ÓÏÂÀ´ÎһὫ×Ô¼ºµÄËù¼ûËùÎźÍһЩʵÓõľÑéºÍ´ó¼Ò̽ÌÖһϣº
²ã¼¶½á¹¹µÄÊý¾Ý±£´æÔÚƽÃæµÄÊý¾Ý¿âÖлù±¾ÉÏÓÐÁ½ÖÖ³£ÓÃÉè¼Æ·½·¨£º
1¡
Ïà¹ØÎĵµ£º
À´×Ô:http://www.cnblogs.com/mikeye/archive/2007/04/13/711878.html
ºÍÀ´×Ô:http://tech.ccidnet.com/art/3539/20080225/1370107_1.html
ÓÃeclipseÀ´½øÐÐMicrosoft SQL Server 2005Êý¾Ý¿â·½ÃæµÄ¿ª·¢£¬ÏÈ°ÑMS SQL Server 2005 JDBC DriverµÄÇý¶¯ÏÂÔغó¼ÓÈ빤³ÌÎļþµÄÀà¿âÖУ»È»ºóдURL×Ö·û´®¡£¸ù¾ÝÒÔÍùµÄд·¨Ð´È룺url = ......
--µ±Á½¸ö»òÁ½ÒÔÉϵIJÙ×÷Ҫô¶¼Ö´ÐУ¬ÒªÃ´¶¼²»Ö´ÐÐʱҪÓÃÊÂÎñ¡£
1. Sqlд·¨(ÊÂÎï+Óαê)
--¿ªÊ¼ÊÂÎñ
BEGIN TRAN
--²»ÏÔʾ¼ÆÊýÐÅÏ¢
SET NOCOUNT ON
DECLARE @ProjNo varchar(50),@CusNo varchar(50)
--ÉùÃ÷Óαê
DECLARE CRMPSContact_cursor CURSOR FOR
SEL ......
ʹÓÃVB°ÑExcelµ¼Èëµ½SqlÊý¾Ý¿âÖУ¬ÆäʵÓм¸ÖÖ·½·¨¡£
ÏÂÃæÎÒ½éÉܵÄÕâÖÖ·½·¨£¬½ÏΪ¼òµ¥¡£
ÆäʵÕâÖÖ·½·¨µÄ»°£¬ÊÇÖ±½ÓʹÓÃT-SQL²Ù×÷µÄ£¬Òò´Ë£¬µ½ÁËVBÀïÃ棬ֱ½ÓeccuteÕâ¸ö´úÂë¾ÍOKÁ˵ġ£
-----------------------------------------------------ÏÂÃæÊÇÔÚT-sqlÖеÄÓï¾ä
if object_id('NewTable') is not null/*ÅжϱíNewTabl ......
HO~HO~EXCELÉú³ÉSQL½¨±í´æ´¢¹ý³ÌµÄVBA½Å±¾^_^ÔÞÒ»ÏÂ
2007-12-11 10:39
'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ È«¾Ö±äÁ¿¶¨Òå
Const MAX_COLUMN_NUM = 50
Dim stOutputPath As String
Dim stOutputFile As String
Dim stDBName As String
Dim stUserName As String
Dim stUserPasswd As ......