ÇóÒ»¸ö³É¹¦µÄMSSQLÊý¾Ý¿âÉè¼ÆÀý×Ó
´óϺÃÇ£¬ÎÒÏë×öÒ»¸öÍøÕ¾µÄºǫ́Êý¾Ý¿â£¬ÓÃMSSQL½øÐÐÉè¼Æ£¬ÍøÕ¾µÄÀàÐÍÀàËÆÓÚ¹ºÎïÍøÕ¾£¬ÄÇôÎҵĺǫ́Êý¾Ý¿âÓ¦¸ÃÔõÑùÉè¼ÆÄØ£¿£¿
ÓÐûÓÐÒ»¸ö±È½Ï³É¹¦µÄÊý¾Ý¿âµÄÉè¼ÆÀý×Ó¹²ÔÚÏÂÑо¿Ò»Ï£¿£¿¼±Óõģ¬ÔÚÏߵȡ£¡£¡£¡£¡£
Äã²»ÈçÈ¥ÍøÉÏϸöÏà¹ØµÄϵͳ¿´¿´È˼ÒÔõô¸ãµÄ.
Õâ¸öÒª½áºÏÄãµÄÐèÇó·ÖÎöÀ´
Äã¿ÉÒԲο¼Ò»ÏÂÍøÉÏÏÂÔØµÄϵͳ£¬È»ºó¸ù¾Ý×Ô¼ºµÄÐèÇóÀ´ÐÞ¸Ä
´ó¼ÒºÃŶ
Ïà¹ØÎÊ´ð£º
ÈçºÎÔÚMSSQLÊý¾Ýµ¼ÈëµÄʱºòÓöÉÏ´íÎóÊý¾ÝÌø¹ý?
Õâ¸ö£¿ÄÇÄ㻹ÊÇÓÃssis°É¡£Êý¾Ýµ¼Èëµ¼³öûÓпØÖÆÁ÷
ÊÇ2000µÄÊý¾Ý¿â
2000ûʲôºÃµÄ°ì·¨
ÓÐûÓÐÆäËüµÄµ¼È빤¾ßÄØ?
×Ô¼ºÔÚǰ̨д´úÂëÅжϡ£
·¹ý£¬ÓÃÇ°Ì¨Ê ......
mssql ÅжÏÊÇ·ñÊÇÈÕÆÚ?
SQL code:
declare @var int
set @var= isdate('g')
if @var =0
print '²»ÊÇÓÐЧÈÕÆÚ'
else
print 'ÊÇÓÐЧÈÕÆÚ'
SQL code:
select * from tb where isdate(×Ö¶Î)=1 ......
ÉÌÆ·±í
ProductManager_Name ProductManager_Type_Id
-------------------------------------------------------------
Öйú¾¼ÃÈȵãÑо¿ ......
¿ªÈý¸öÏß³ÌÅÜÏÂÃæµÄÕâ¸ö Do() º¯Êý¾Í»á·¢ÉúËÀËø.
¿ªÈý¸öÏß³ÌÒÔÉÏ,¾Í¸ù±¾Åܲ»ÆðÀ´!.
²»¾ÍÊǶÔͬһÖ÷´Ó±í½øÐÐÔöɾ¸Ä²Ù×÷ô.¾Í1000ÌõÒ²»áÕâÑù,Ì«²îÁË!
C# code:
public void Do()
{
......
MSSQLij×Ö¶ÎijЩÄÚÈÝÌæ»»
ÀýÈç±í S_ORDER , ×Ö¶Î NAME
AAA¾×asdfasd
  ......