mssql ÅжÏÊÇ·ñÊÇÈÕÆÚ?
mssql ÅжÏÊÇ·ñÊÇÈÕÆÚ?
SQL code:
declare @var int
set @var= isdate('g')
if @var =0
print '²»ÊÇÓÐЧÈÕÆÚ'
else
print 'ÊÇÓÐЧÈÕÆÚ'
SQL code:
select * from tb where isdate(×Ö¶Î)=1
ISDATE(Êý)
Ïà¹ØÎÊ´ð£º
MSSQL$SQLEXPRESS ÎÞ·¨Æô¶¯.. ÖªµÀÈçºÎ´¦ÀíµÄÇë°ï°ïæ лл
¿´¿´´íÎóÈÕÖ¾
Ìáʾʲô´íÎó?
http://blog.csdn.net/fredrickhu/archive/2009/09/20/4573408.aspx
......
ÈçÌ⣬Ï뽫ÎÒÒÔÇ°×ö¹ýµÄÍøÕ¾·ÅÔÚÍøÉϸøÈË¿´£¬ÓÉÓÚÊÇms sqlµÄ£¬´ó¶àÊýÍøÂçÉ̵ÄÐéÄâÖ÷»úÊÇÒªÊշѵģ¬
Ïë´ò°üºó·ÅÔÚһЩÃâ·ÑµÄ¿Õ¼ä£¬ÈÃÈ˼Ò×Ô¼ºÏÂÔØÈ¥¿´£¬ËùÒÔÏ£Íû´ò¹ý°üºóµÄÊý¾Ý¿âµÄ±í²»Èÿͻ§¿´µ½£¬
»òÕßÊǼӹý ......
ÈçºÎÔÚMSSQLÊý¾Ýµ¼ÈëµÄʱºòÓöÉÏ´íÎóÊý¾ÝÌø¹ý?
Õâ¸ö£¿ÄÇÄ㻹ÊÇÓÃssis°É¡£Êý¾Ýµ¼Èëµ¼³öûÓпØÖÆÁ÷
ÊÇ2000µÄÊý¾Ý¿â
2000ûʲôºÃµÄ°ì·¨
ÓÐûÓÐÆäËüµÄµ¼È빤¾ßÄØ?
×Ô¼ºÔÚǰ̨д´úÂëÅжϡ£
·¹ý£¬ÓÃÇ°Ì¨Ê ......