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

ÇóÒ»ÌìSQLÓï¾ä

Çë´ó¼Ò°ï°ïæ ÎÒÓÐÒ»¸öÕâÑùµÄ±í
  id name PosIDs
  1 XX 1,2
  2 X1 1,3
  3 X2 2,3

 ÓÃʲôÑùµÃ²éѯÓï¾ä¿ÉÒÔ

  ²é³ö

  id = 1 name = XX posID = 2
SQL code:
select * from tb where id=1


select * from tb where id=1 and name='XX' and posids=2
????

SQL code:
select * from tb where id=1


ÓÐÖ÷¼üÂ𡣡£¡£¡£¡£

ÎÒÃÇÒÉ»ó

SQL code:
select id = 1 name = XX posID = 2


ÒýÓÃ
SQL code
select * from tb where id=1


Èç¹ûÄãÕâÑù²éµÄ»° ½á¹ûÊÇ

 id = 1 name = XX posID = 1,2

select * from tb where id=1 and name='XX' and posids=2

Õâ´ð°¸Ö±½ÓÄãû¿´????

ÒýÓÃ
SQL code
select id = 1 name = XX posID = 2


posID = 1,2 ¿ÉÒÔÕâÑù²é£¿

SQL code:
select * from tb where id=1 a


Ïà¹ØÎÊ´ð£º

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

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

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......

SqlÓï¾ä³ö´í£¬ - Web ¿ª·¢ / ASP

ÔËÐк󱨴íÎóÈçÏ£º
´íÎóÀàÐÍ£º
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ 'Êýѧ + 4where ÐÕÃû='Íõ¾²'' ÖС£
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ