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

sql server ifǶÌ×»ù±¾Óï·¨

Àý×Ó£º
if 1<>1
begin
   if  5<0
      begin
            print('ʧ°Ü')
       end
       else begin
            print('chengong')     
       end
end
else begin
          print('cuowu')
end


Ïà¹ØÎĵµ£º

SQLº¯ÊýÖ®ÆäËûº¯Êý

MySQLÖÐÎIJο¼ÊÖ²á- 7 MySQL ÓïÑԲο¼
<!--
body { font-size: 9pt; }
a:hover{color:red;}
a.t1:visited{color:red;}
-->
DATABASE()

·µ»Øµ±Ç°µÄÊý¾Ý¿âÃû×Ö¡£
mysql> select DATABASE();
-> 'test'
Èç¹ûûÓе±Ç°µÄÊý¾Ý¿â£¬DATABASE()
·µ»Ø¿Õ×Ö·û´®¡£
USER()

¡¡
SYSTEM_USER() ......

SQLÈýÖÖ·ÖÒ³·½·¨

Ô­ÎĵØÖ·£ºhttp://topic.csdn.net/u/20100203/17
/8F916471-597D-481A-B170-83BCEFE3B199.html
============================ÎÒÊÇ·Ö¸î
·û================================
Ó¦Ò»¸öÅóÓѵÄÒªÇó£¬ÌùÉÏÊղصÄSQL³£Ó÷ÖÒ³µÄ°ì·¨¡«¡«
±íÖÐÖ÷¼ü±ØÐëΪ±êʶÁÐ
£¬[ID] int IDENTITY (1,1)
1.·ÖÒ³·½°¸Ò»£º(ÀûÓÃNot InºÍSELECT ......

javaÀàÖÐдsqlÓï¾ä£¬²éѯÌõ¼þ°üº¬»»ÐÐ

detachedCriteria.add(Restrictions.or(
       Restrictions.like("chengBanDanWeiIds", rForm.getChengBanDanWeiIds()+(char)13, MatchMode.START),
       Restrictions.or(
          &n ......

SQL×¢ÈëÈëÇÖ¶¯ÍøSQL

±à¼­Ç°ÑÔ£ºÕâ¸öÎÄÕÂÎÒûÓвâÊÔ£¬µ«Ç°ÌáÌõ¼þ»¹ÊǺܶ࣬±ÈÈçÒ»¶¨ÒªÓбðµÄ³ÌÐò´æÔÚ£¬¶øÇÒÒ²ÒªÓÃͬһ¸öSQLSERVER¿â£¬»¹µÃ¼ÙÉèÓÐ×¢Èë©¶´¡£Ëµµ½µ×ºÍ¶¯ÍøÃ»ÓÐʲô¹ØÏµ£¬µ«ÒòΪ¶¯ÍøÂÛ̳µÄ¿ª·ÅÐÔ£¬ÈÃÈËÊìϤÁËÆäÊý¾Ý¿â½á¹¹£¬ºÍ³ÌÐòÔË×÷·½·¨¡£ÔÚÒ»²½²½µÄ¹¥»÷ÖÐÈ¡µÃ¹ÜÀíȨÏÞ£¬ÔÙÒ»²½²½µÄÌáÉýȨÏÞ£¬Èç¹ûÕýºÃÊý¾Ý¿âÓõÄÊÇSAÕʺţ¬¾Í¸üÊÇ ......

SQLÖд洢¹ý³ÌÖÐSQLÓï¾äµÄµ¥ÒýºÅºÍË«ÒýºÅÎÊÌâ

    Ö£ÖØÉùÃ÷һϣ¬ÕâÆªÈÕÖ¾ÊÇÎÒCopyµÄ£¬²»ÊÇ×Ô¼ºÐ´µÄ£¬ÎÒ»¹Ã»ÄÇôǿ£¡(×Ðϸ¿´Ò»Ï£¬ÓÐÓá£)
¹ØÓÚSQLÓï¾äÖеÄË«ÒýºÅ¡¢µ¥ÒýºÅ£º
£¨1£©ÏÈÀ´¿´Ò»¸ö×î¼òµ¥µÄSQLÓï¾ä
            Insert Into users(username) values("СÍõ")
    ´ó¼ÒÀ´¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ