¼±£¬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
½»ÓÑÂÛ̳£¡£¡
....................°Ñ½¨±í½Å±¾Ê²Ã´Ìù³öÀ´,ÔÙ½âÎöÒ»ÏÂËãÁË.......
ÂÛ̳²»¾ÍÊÇ´ó¼ÒÒ»Æð½»Á÷µÄ µØ·½¶àÒ»¸öÅóÓѶàÒ»·ÖÁ¦Á¿£¬ºÇºÇ ¿ªÂÛ̳²»¾ÍÊÇÕâ¸öÒâ˼Âð£¬
Ïà¹ØÎÊ´ð£º
sqlÎÒÏëµÃµ½Ò»×Ö·û´®Îª:
sldkf|||sdeww
erkv|||rltdk
jemcl|||ligf
¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð»
ÔνñÌì²»ÊÇдÁËô
select parsen ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......