Access Êý¾Ý¿âÖÐ table1 ÖÐ ÒѾÓÐÒ»¸ö×Ö¶ÎÃû½Ð col ¿ªÊ¼µÄĬÈÏÖµÊÇ0
Èç¹û¾¹ýsql °ÑĬÈÏÖµ±ä³É 11
ÔÚADOÖУº ALTER TABLE COL INT DEFAULT 11
VBA: CurrentProject.Connection.Execute "ALTER TABLE COL INT DEFAULT 11" ALTER TABLE table1 ALTER COL INT DEFAULT 11
ΪʲôÔÚaccess ÊÓͼÖÐÖ´ÐÐ ²»ÁË
ÊDz»ÊÇÒ»¶¨Òªado.net ? ÔÚ²éѯÖв»ÐУ¬±ØÐëÔÚADOÖУ¬ÉÏÊö´úÂëÓÐÎÊÌ⣬ÐÞ¸Ä ALTER TABLE table1 ALTER COL INT DEFAULT 11 û°ì·¨£¬£Á£Ã£Ã£Å£Ó£ÓµÄ²éѯÖв¢²»Ö§³ÖÕâ¸ö defaultµÄ¶¨Òå¡£Ö»ÄÜͨ¹ý£Á£Ä£ÏÀ´Ö´ÐС£¡¡²»ÐèÒªÓãÁ£Ä£Ï¡££Î£Å£Ô ¶÷ºÜºÃ¡£»Ø´ðµÄ²»´í¡£¶¼¸ø·Ö