Mssql2005 xml ²éѯ ʹÓà exist - .NET¼¼Êõ / C#
SQL code:
@uid int
@money float
If not exists(SELECT null from bc_users_table where bet_id=@uid and bet_hk_rationing.exist('/root/items[@straight_bet>'+@money+']') = 1)
--BEGIN
select '1111¡®
--RETURN
END
exist ²ÎÊý 1 ±ØÐëΪ ÖÐÎÄ×Ö·û£¿
ÄÄλÅóÓÑÓöµ½¹ýÏàͬÎÊÌâ °ïæ½â´ðÒ»ÏÂ
http://topic.csdn.net/u/20100407/11/472586ae-1b77-4045-aa21-f7d1d011ad0c.html
лл£¬µ«ÊǺÃÏñÎ޹صÄàÞ
exist Õâ¸öÊÇ×Ô¶¨Ò庯Êý°É
°ÑÄǺ¯ÊýÌù³öÀ´ ¿´¿´ËûÐèÒª´«ÄÄЩ²ÎÊý
Ïà¹ØÎÊ´ð£º
ÈçºÎÓÃATL´°ÌåÓ¦ÓóÌÐòÖÐÓÃSystem.Xml±éÀúÒ»¸öXmlÎļþ
Äã˵µÄÊÇÍйܴúÂ룿
¡£
vc¿ÉÓÃmsxml
http://msdn.microsoft.com/en-us/library/ms767594(VS.85).aspx
MSXML4
//ÒýÈëmsxml4.dll &nbs ......
˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
<time times='01:12:00' timee='02:30:00'> ......
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44
Í ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
ʹÓÃACCESS×î´óµÄÒþ»¼¾ÍÊDz»°²È«¡£½ñÌì¶ÔACCESSÊý¾Ý¿âÉèÖÃÁËÒ»¸öÃÜÂ룬±ØÐëʹÓÃÃÜÂë²ÅÄÜ´ò¿ª£¬µ«ÊÇÔÚ³ÌÐòÖÐÈ´ÎÞ·¨Á¬½ÓÊý¾Ý¿âÁË¡£´ó¼ÒÖªµÀʹÓÃÓû§ÃûºÍÃÜÂ룬ÈçºÎÁ¬½ÓACCESSÊý¾Ý¿â£¿Ã²ËÆACCESSµÄÓû§Ãû»¹²»ÖªµÀ£¿Ö»Öª ......