¼±£¬sql,
ÈçºÎʵÏÖ
¿´²»µ½Í¼Æ¬£¡
àÅ
..
¡£¡£
ÎÞͼÎÞÕæÏà
ºÇºÇ
Ã×ͼ
ͼƬ·¾¶Ôõôд°¡
ʵÔÚ²»ÐУ¬·¢¸öÁ´½ÓÉÏÀ´Ò²Ðа¡£¡
º¹.......¸æËßÎÒÃÇÄúµÄ¾Î³¶È°É,ÎÒÃÇ¿ÉÒÔͨ¹ýGOOGLEµØÍ¼,ÒýÓÃÏȽøµÄÎÀÐÇ,²éÕÒµ½ÄúËùÔڵĵØÖ·,ÒÔ¼°¼àÊÓÄúÒ»ÇеÄÐж¯,µ±È»Ò²ÄÜ¿´µ½ÄúµÄͼƬÁËÀ
1 ft3001 1 5 100.00 2010-01-20 00:00:00.000 1
1 ft3001 ³¤´º ¹þ¶û±õ 100.00 2010-01-20 00:00:00.000 1
Ò»¸öÖ÷Íâ¼ü£¬×Ö¶Î CityInfo (cityId,cityname)
Ticket(fromCityId,ToCityId)
GZ
Â¥ÉϵÄÔÛÁ©ÄܳÉΪºÃÓѲ»£¬QQ522314565
½»ÓÑÂÛ̳£¡£¡
....................°Ñ½¨±í½Å±¾Ê²Ã´Ìù³öÀ´,ÔÙ½âÎöÒ»ÏÂËãÁË.......
ÂÛ̳²»¾ÍÊÇ´ó¼ÒÒ»Æð½»Á÷µÄ µØ·½¶àÒ»¸öÅóÓѶàÒ»·ÖÁ¦Á¿£¬ºÇºÇ ¿ªÂÛ̳²»¾ÍÊÇÕâ¸öÒâ˼Âð£¬
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......