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

SQLÖбäÁ¿µÄÒÉ»ó

if(@tt25=1)
begin
print 'A'
select @t25=max(Qs) from Arn where A25=1 and Qs <@id
print 'B'
print @t25
if(@t25=Null)
begin
print 'C'
print @t25
print'D'
set @t25=0
print @t25
print 'E'
end
print 'F'
print @id
print @t25
print 'G'
set @t25=@id-@t25
end

ÔËÐкóÊä³ö
A
B
    //¿ÕÁËÒ»ÐÐ
F
2//@idµÄÖµ
  //ÓÖ¿ÕÁËÒ»ÐÐ
G

ÎҵIJ»½âÊÇ
¿ÕµÄÄÇÒ»Ðж¼ÊÇprint @t25
Ϊʲô»á¿Õ£¿
ÊDz»ÊÇÒòΪ@t25
ΪNULL£¿

¿ÉÊÇ Åж¨Óï¾äif(@t25=Null)
begin
print 'C'
print @t25
print'D'
set @t25=0
print @t25
print 'E'
end
ÓÖûÓÐÖ´ÐС£¡£¡£

Çó½â¼° ½â¾ö·½°¸
ÒòΪ@t25£½null
ËùÒÔÒ»Çз¢·¢ÉúÁË£­¡¡£­

print null ¾ÍÊǿհ׵ÄÐÐ
µÚÒ»¸öprint @t25
ÏÔʾ¿Õ°×ÐÐ
if(@t25=Null) £­£­ÎÞ·¨Ê¶±ð¿ÕÐÐËùÒÔÌø¹ý
µÚ¶þ¸öprint @t25
¼ÌÐøÏÔʾ¿Õ°×

£­£­ÒÔÉÏ

½â¾ö°ì·¨£¿
²»ÖªµÀÄãÒªÔõôÑùµÄЧ¹ûÎÒÒ²²»ÖªµÀÔõô˵½â¾ö°¡

ÊÇ·ñÏëÈÃnullÕý³£±»Åжϣ¿
ÕâÑùÐв»
if (isnull(@t25,'0')£½'0')



µ±È»ÕâÑùÒ²ÐÐ

if (@t25 is null)

»òÕß
if (@t25 is not nu


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ