Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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º¯ÊýÖ®×Ö·û´®º¯Êý


Èç¹û½á¹ûµÄ³¤¶È´óÓÚ·þÎñÆ÷²ÎÊýmax_allowed_packet£¬×Ö·û´®Öµº¯Êý·µ»ØNULL¡£¼û10.2.3 µ÷½Ú·þÎñÆ÷²ÎÊý¡£
¶ÔÓÚÕë¶Ô×Ö·û´®Î»ÖõIJÙ×÷£¬µÚÒ»¸öλÖñ»±ê¼ÇΪ1¡£
ASCII(str)
·µ»Ø×Ö·û´®strµÄ×î×óÃæ×Ö·ûµÄASCII´úÂëÖµ¡£Èç¹ûstrÊÇ¿Õ×Ö·û´®£¬·µ»Ø0¡£Èç¹ûstrÊÇNULL£¬·µ»ØNULL¡£
mysql> select ASCII('2');
-> ......

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

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

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

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

SQL*PlusÖÐ&×Ö·û´¦Àí

ÔÚSQL*PlusÖÐĬÈϵÄ"&"±íÊ¾Ìæ´ú±äÁ¿£¬SQL*PlusÈÏΪ&·ûºóÃæµÄ×Ö·û´®Îª±äÁ¿£»Ö»ÒªÔÚÃüÁîÖгöÏָ÷ûºÅ£¬SQL*Plus¾Í»áÒªÄãÊäÈëÌæ´úÖµ¡£Õâ¾ÍÒâζ×ÅÄãÎÞ·¨½«Ò»¸öº¬Óи÷ûºÅµÄ×Ö·û´®²åÈë»ò¸üе½Êý¾Ý¿â
     
set define off ¹Ø±ÕÌæ´ú±äÁ¿¹¦ÄÜ£¬“&”½«×÷ΪÆÕͨ×Ö·û
set def ......

asp.netÁ¬½ÓsqlÓõÄSqlHelper

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Collections;
using System.Data.SqlClient;
namespace DAL
{
    /// <summary>
    /// Êý¾Ý¿âµÄͨÓ÷ÃÎÊ´úÂë
    /// ´ËÀàΪ³éÏóÀ࣬²»ÔÊÐíʵÀý»¯£¬ÔÚÓ¦Óà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ