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 Õâ¸öÊÇ×Ô¶¨Ò庯Êý°É
°ÑÄǺ¯ÊýÌù³öÀ´ ¿´¿´ËûÐèÒª´«ÄÄЩ²ÎÊý