accessÊý¾Ý¿â°ïæÉè¼ÆÈçϱí
Âé·³¸øÏ¾ßÌå·½·¨Ð»Ð»£¡
students(ID, Name)
attendences ( ID, aDate )
Ö÷ÒªÊǺóÃæÄǸöʱ¼ä Äܲ»ÄÜ×Ô¶¯²úÉú£¿
¸ßÊÖÃǰï°ïæѽ...
Ö÷ÒªÊǺóÃæÄǸöʱ¼ä Äܲ»ÄÜ×Ô¶¯²úÉú£¿
ʲô½Ð×Ô¶¯²úÉú?
¸ù¾Ýµ±Ììʱ¼ä×Ô¶¯Éú³É¿ÉÒÔ²»£¿ »¹ÊDZØÐë×Ô¼ºÌí¼Ó...
¸ù¾Ýµ±Ììʱ¼ä×Ô¶¯Éú³É¿ÉÒÔ²»£¿
ʲô½Ð "¸ù¾Ýµ±Ììʱ¼ä×Ô¶¯Éú³É" ?
ʲôÈ˶¼²»²Ù×÷£¬Ã¿ÌìÔçÉÏ£²µã×Ô¶¯ÔÚÊý¾Ý¿âÖÐÉú³É¼Ç¼£¿
ÎÊÌâ˵Ã÷Ô½Ïêϸ£¬»Ø´ðÒ²»áԽ׼ȷ£¡²Î¼ûÈçºÎÌáÎÊ¡££¨ÌáÎʵÄÖǻۣ©
²»ºÃÒâ˼ ...ÐÂÊÖ ¶Ô¶Ô ¾ÍÊÇÄã˵µÄÒâ˼£¡Â¥ÉϸßÊÖѽ£¡ÄÜ×Ô¶¯Êý¾Ý¿âÖÐÉú³Éµ±ÌìµÄʱ¼äÂ𠣿
2010Äê4ÔÂ12ÈÕ 2010Äê4ÔÂ13 ...һֱÿÌì¶¼ÓÐ
ÊÇ·ñ³öÇÚ ÊÇ·ñ³öÇÚ ÊÇ·ñ³öÇÚ×Ô¼ºÌí¼Ó
ÉÏÃæÈÕÆÚ×Ö¶ÎÄÜ·ñÏòÄú˵µÄÄÇÑùÿÌì×Ô¶¯Éú³É£¿
{{
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
CREATE TABLE Product(model integer,
maker varchar(20),
CONSTRAINT SAND PRIMARY KEY (model),
CONSTRAINT PANDA FOREIGN KEY (model) REFERENCES PC (model)
ON DELETE CASCADE ......
Çë´óÏÀÖ¸µã£¬¹òлÁË£¬×îºÃÓдúÂë
ÒªÓõ½ADOX¶ÔÏ󣬲éϰïÖúÎĵµ£¬
http://hyadliujing.blog.163.com/blog/static/4484507420091020969233/?mode=edit
ûÓÐÕÒµ½°¡ ¿´ÁËÄãµÄ²©¿ÍÁË£¬ÎÒÊÇÏ뽫accessÀïÃæµÄ¸½¼þ±£´æ ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£
Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......
¾ÍÊÇÊÇ·ñÖ§³Ö¶à¸öÁ¬½ÓµÄ²Ù×÷£¿ÔÚÒ»¸ö³ÌÐòÁ¬½ÓÕâ¸öÊý¾Ý¿âʱ£¬ÁíÒ»¸ö³ÌÐò»¹ÄÜÔÙÁ¬½ÓÕâ¸öÊý¾Ý¿âÂð£¿
×î¶àÖ§³Ö¶àÉÙ²¢·¢Á¬½Ó£¿
Ö§³Ö¡£
http://msdn.microsoft.com/en-us/library/ms810829.aspx
×î¶àÖ§³Ö¶àÉÙ²¢· ......