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

ÇóÒ»SQLÓï¾ä - MS-SQL Server / Ó¦ÓÃʵÀý

Óжà¸öÓû§,¶øÃ¿¸öÓû§ÓÖ·¢²¼Á˺ܶàÐÅÏ¢,ÎÒÏëÌáȡÿ¸öÓû§Í¨¹ýÉóºËµÄ×îÐÂÈýÌõÐÅÏ¢,Ò²¾ÍÊÇÿ¸öÓû§Ö»ÌáÈ¡Ëû·¢²¼µÄ×îÐÂÈýÌõÐÅÏ¢,°´ÕÕ½ðÅÆ»áÔ±,ÒøÅÆ»áÔ±,ÆÕͨ»áԱ˳ÐòÅÅÐò¡£ ÓÐÁ½¸ö±í,Ò»¸ö»áÔ±±í,Ò»¸ö¼Û¸ñ±í,Á½¸ö±í×îºÃͨ¹ýgs_id¹ØÁª£¬ÒÔ·½±ã»áÔ±ÅÅÐò

Ïàͬgs_id×î¶àÏÔʾ3Ìõ¼Ç¼  
  ±í½á¹¹ÈçÏ£º  
  id cunname gs_id  
  1 a 1  
  2 b 1  
  3 c 1  
  4 d 1  
  5 e 2  
  6 f 2  
  7 g 2  
  8 h 2  
  9 i 2  
  10 j 3
You need to provide the table structure clearly. What are the table names, and what are the columns and how are they linked?


SQL code:
----------------------------------------------------------------
-- Author :fredrickhu(СF£¬Ïò¸ßÊÖѧϰ)
-- Date :2010-05-06 20:54:09
-- Version:
-- Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86)
-- Nov 24 2008 13:01:59
-- Copyright (c) 1988-2005 Microsoft Corporation
-- Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
--
---------------------------------------------------------


Ïà¹ØÎÊ´ð£º

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ