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

¹ØÓÚMSSQLĬÈÏÖµµÄÎÊÌâ

ÎÒÔÚMSSQL¹ÜÀíÆ÷Àï°Ñн¨×Ö¶Îstr

ÔÚĬÈÏÖµ»ò°ó¶¨ÄÇÀïÎÒÌîдÁË0

È»ºóÎÒ·¢ÏÖ¡£Èç¹ûÎÒÔÚÔö¼Ó¼Ç¼ʱ¡£Õâ¸öSTR²¢²»ÊÇĬÈϵÄ0¶øÊÇNULLÔõô»ØÊ£¿£¨ÔÚÔö¼Ó×Ö¶Îʱ¡£ÎÒûÓмÈërs("str")µÄÖµ¡£Ô­±¾ÒÔΪÕâÑù»áÏëMDBÄÇÑù£¬ËüÖ±½Ó˵0.Ë­ÖªµÀ»¹ÊÇNULL¡£º¹£©

±¾È˸ջ»MSSQL¡£ÇëÁ½â

ÔÚĬÈÏÖµÄÇÀïÉèÖÃÓ¦¸ÃûÎÊÌâµÄ

ÔÚ²åÈëÊý¾ÝµÄÊÇÖ¸¶¨ÆäËûµÄÁкÍÖµ¼´¿É
Èç tb(id int,str varchar(10))

insert tb(id) values(10)

½á¹ûΪ
10 0

ÎÒÓõÄÊÇRS.ADDNEWS¸üеÄÊý¾Ý¡£»á²»»áÓÐÓ°Ïì

ÒýÓÃ
ÎÒÓõÄÊÇRS.ADDNEWS¸üеÄÊý¾Ý¡£»á²»»áÓÐÓ°Ïì


Õâ¸ö²»ÊǺÜÇå³þ£¬Äã¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷ÓÃsqlÓï¾ä²åÈëÊý¾Ý²âÊÔÒ»ÏÂ

Õý³£Çé¿ö²»»á¡£¡£
¡£¡£¡£¡£¡£¡£¡£¡£

ÒýÓÃ
ÎÒÓõÄÊÇRS.ADDNEWS¸üеÄÊý¾Ý¡£»á²»»áÓÐÓ°Ïì

²»»á

¿ÉÒÔÊÔ×ŰÑÉèÖÃĬÈÏÖµµÄ×Ö¶ÎÉèÖÃΪnot null£¬ÔÙ²âÊÔ¿´¿´ÄÄÀï³öµÄÎÊÌâ


Ïà¹ØÎÊ´ð£º

MSSQL ת»» MYSQL

ÈçºÎ½«MSSQLÊý¾Ý¿âת»»ÎªMYSQL
ÔÚÍøÉÏÕÒÁ˺ܶà ˵µÄºÜÂÒ ÇëÎÊÓиßÊÖ¿ÉÒÔ½ÌÏÂÂð ллÁË
ûÓÐʲôºÃ°ì·¨¡£Á½ÕßÖ®¼ä»¹ÊÇÓÐЩ²îÒìµÄ¡£

Êý¾ÝÀàÐÍ£¬´æ´¢¹ý³ÌÓï·¨¡£

Èç¹ûÖ»ÊDZíºÍ¼Ç¼£¬Ôò¿ÉÒÔ°²×°Ò»¸öMYS ......

MSSQLÔõô»ñÈ¡Êý¾Ý¿âÀúÊ·²éѯ×Ü´ÎÊý

ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É


ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..

ÄÇÓÐûÓÐϵͳ´ ......

¸ßÊÖ¿ìÀ´¾È¾ÈÎÒ¡£MSSQL²éѯÎÊÌâ

Dim Rs:Set rs=key28.exe("select [id],[big],[class] from lm_small")
Do while not rs.eof
    Dim rs1:Set rs1=key28.exe("select [class] from [lm_class] where id="& ......

mssql ÈçºÎ¼Èë 2008-1-1 ÕâÑùµÄʱ¼ä¸ñʽ

ÎÒÓÃ("insert into LM_info ([content],[date],[username]) values ('"&content&"',date(),'"&username&"')")
ÊÇ´íÎóµÄ¡£

µ«ÊÇÎÒÓÃgetdat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ