ado+sql´´½¨±í
¸÷λ´ó¼ÒºÃ
VC+ado+sql´´½¨±í
ÎÒÊý¾Ý¿âÀïÓÉÒ»ÕÅTABLE±í£¬ÏÖÔÚÎÒÒªÒ»ÕÅTABLE1±í¡££¨×¢£ºÎÒËù½¨µÄTABLE1±íͨ¹ý¶Ô»°¿òÉϵÄÒ»±à¼¿òÊäÈ룬µã»÷°´Å¥ºóÒª½¨Á¢TABLE1±í£¬²¢ÇÒTABLE1±íÖеÄËùÓÐ×Ö¶ÎÊÇ´ÓTABLE±íÖжÁ³ö£¨³ýTABLE±íÖеĵÚÒ»¸öID×ֶΣ©Ò²¾ÍÊÇ˵TABLE1ÖеÄ×ֶκÍTABLEÖеÄÒ»Ñù³ýID×Ö¶ÎÍ⣩£¬Õâ¸öÎÊÌâÔõô½â¾öѽ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
лл
ÔõôûÓÐÈ˻شð£¬Õâ¸öÎÊÌâºÜÄÑÂ𣿣¿£¿£¿£¿£¿
SELECT CASE WHEN a.colorder = 1 THEN d.name ELSE '' END AS userynht,
//ºì×Ö±êʶµÄÊÇÄãÒª¶ÁÈ¡µÄ±í
ÄãµÄQQÔÚÏßÂð£¿
Ïà¹ØÎÊ´ð£º
СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
@p001 nvarchar(8000),
@p002 nvarchar(8000),
@p003 nvarchar(8000),
& ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
ÎÒÓÐÒ»¸öÔºÍÈÕ×é³ÉµÄÊý×Ö£¬ÓÐÁ½×éÔºÍÈÕ
ÏëÔÚÉí·ÝÖ¤ºÅÖÐÌôÑ¡³öÔڸøÃÁ½×éÔÂÈÕÖ®¼ä³öÉúµÄÈË£¬²»ÖªµÀÓ¦¸ÃÔõôд.
Éí·ÝÖ¤ºÅÓпÉÄÜÊÇ15λ»òÕß18λ
ÔÂÈÕ×éºÏµÄÐÎʽÈçÏÂ
10-17/04-20
ÔÂ-ÈÕ/ÔÂ- ......
PHP code:
½«Êý¾Ý¿âÖеÄproc¶¼Ö´ÐÐÒ»±é
²»»áÊÇ EXEC sp_MSforeachtable£¿¿Ï¶¨²»ÊÇÀ²£¬ÊÇÊ²Ã´ÄØ£¿
這個²»Ì«現實°É,ÓеÄÓÐ參數ÓеÄ沒ÓÐÔõ麼辦?
Èç¹ûË ......
t_a{
id ,
name,
age,
pid, ¶ÔÓ¦t_b(id)
}
t_b{
id£¬
ywlx£¬
}
±¾ÈËÏëÓÃ
ÕâÖÖÀàÐ͵IJéѯ
String sql = "select name,age,y ......