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

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


Ïà¹ØÎÊ´ð£º

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

c#Éú³ÉxmlÎļþ - .NET¼¼Êõ / C#

˼·£ºÒªÓÃc#Éú³ÉÒ»¸ö²¥·Å»úµÄ²¥·ÅÁбíµÄxml£¬ÀýÈ磺
<daty datys='2010-04-05' datye='2010-05-01' > //ÕâÊDz¥·ÅµÄÈÕÆÚ¶Î
  <time times='01:12:00' timee='02:30:00'> ......

XmlDocumentÈçºÎÉú³É±ÕºÏ±ê¼ÇµÄXML - .NET¼¼Êõ / C#

ÎÒÓÃXmlDocumentÉú³ÉXML
XmlElement remarkNode = node.OwnerDocument.CreateElement("remark");
remark1Node.InnerXml = "";
Èç¹ûInnerXml¸³Öµ²»Îª¿Õ£¬ÔòÉú³ÉµÄ±ê¼ÇÊÇûÎÊÌâµÄ£¬±ÈÈ磺<r ......

phpÁ¬½ÓMSSQL Á¬²»ÉÏ - PHP / »ù´¡±à³Ì

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
Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ