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ÔÚÏßÂð£¿
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123
aspÀïÃæ strday=100£¬strb=001
ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
Ñ¡³öÊý¾Ý¿âÖÐÈ«²¿µÄ ÒÔ el_ ¿ªÍ·µÄ ´æ´¢¹ý³ÌÃû
ÒÔ¿Õ¸ñ¸ô¿ª
ÒýÓÃ
ÒÔ¿Õ¸ñ¸ô¿ª
SQL code:
declare @s varchar(8000)
select
@s=isnull(@s+' ','')+name
from
sys.objects
where
......
t_a{
id ,
name,
age,
pid, ¶ÔÓ¦t_b(id)
}
t_b{
id£¬
ywlx£¬
}
±¾ÈËÏëÓÃ
ÕâÖÖÀàÐ͵IJéѯ
String sql = "select name,age,y ......