Access ´íÁË£¬»¹ÊÇÎÒɵÁË
×î½üϵͳÔËÐÐÖз¢ÏÖAccess 2003 °æ±¾ÖжԴý Null ºÍ ‘’ £¨¿Õ×Ö·û£©Ææ¹ÖÎÊÌ⣬ÖØÏÖ²½Ö裺
1¡¢´´½¨±ítabTest £»
2¡¢Ê¹ÓÃÉè¼ÆÊÓͼÌí¼ÓÁ½¸ö×ֶΠID £¬col1
Ãû³Æ
ÀàÐÍ
³¤¶È
˵Ã÷
ID
Number
Ö÷¼ü£¬×ÔÔö
Col1
char
1
ÎÞ
3¡¢Ê¹ÓÃsql Ìí¼ÓÈçÏÂÊý¾Ý
-- col1 ×Ö¶ÎÉèÖÃΪ null
INSERT INTO tabtest (id, col1) VALUES(1, NULL);
-- col1 ×Ö¶ÎÉèÖÃΪ ‘’
INSERT INTO tabtest (id, col1) VALUES(2, '');
-- col1 ×Ö¶ÎÉèÖÃΪ ‘a’
INSERT INTO tabtest (id, col1) VALUES(3, 'a');
4¡¢ÖØн¨Á¢²éѯÇëÇó£¬Í¨¹ý sql Ìí¼ÓÐÂ×ֶΠcol2
-- Ìí¼ÓÐÂÁÐcol2
ALTER TABLE tabTest ADD COLUMN col2 CHAR(1);
5¡¢Ê¹ÓÃÈçÏÂsql ÔÙ´ÎÏò tabTest Ìí¼ÓÐÂÊý¾Ý
-- col1£¬col2 ×Ö¶ÎÉèÖÃΪ null
INSERT INTO tabtest(id, col1, col2) VALUES(4, NULL, NULL);
-- col1£¬col2 ×Ö¶ÎÉèÖÃΪ ‘’
INSERT INTO tabtest(id, col1, col2) VALUES(5, '', '');
-- col1£¬col2 ×Ö¶ÎÉèÖÃΪ ‘a’
INSERT INTO tabtest(id, col1, col2) VALUES(6, 'a', 'a');
6¡¢´ò¿ª tabTest ¼ì²é Id Ϊ 5 µÄÊý¾Ý¡£ÉñÆæµÄÊÂÇé·¢ÉúÁË¡£
col1 ×Ö¶ÎΪ ³¤¶ÈΪ0 µÄ¿Õ×Ö·û´®£¬¶ø col2 Ϊ³¤¶ÈΪ1 µÄ×Ö·û
ÎÊÌ⣺
Q1¡¢ÎªºÎ ID Ϊ 2 µÄcol1 ×ֶΠºÍ col2 ×ֶζ¼Êdz¤¶ÈΪ 0 µÄ¿Õ×Ö·û£¬
¶ø ID Ϊ 5 µÄcol1 ×ֶΠºÍ col2 ×ֶγ¤¶È·Ö±ðΪ 0, 1 µÄ¿Õ×Ö·û£¬
ÔËÐÐÈçÏÂsql µÃµ½ÈçϽá¹û£º
SELECT id, len(col1) AS col1_³¤¶È, len(col2) AS col2_³¤¶È
from tabtest
WHERE id IN (2, 5);
Q2¡¢Í¨¹ýÈçÏÂsql È´Äܵõ½ID Ϊ5 µÄ¼Ç¼
SELECT *
from tabtest
WHERE col1 = ''
AND col2 = '';
Ïà¹ØÎĵµ£º
http://www.cnblogs.com/byeday/archive/2009/10/04/1578034.html
ÎÊÌ⣺“Failed to access IIS metabase”½â¾ö
2009-08-14 17:03
ÔÒò£ºIISûÓÐ×¢²á
½â¾ö°ì·¨£º
ÔÚCMDÖнøÈëĿ¼C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727£¬ÔËÐÐaspnet_regiis
1¡¢aspnet_regiis -ga administrator£¨administratorΪµ ......
µ±È»£¬altera FPGA µÄJTAGºÍASÏÂÔØģʽÊǵÃÕâô½Ó¡£µ«ÊÇ£¬ÎÒÓиöСÌáÐѸø¸÷λ£ºÇë×¢ÒâVCCAµÄ¶¨Ò壬VCCAÊÇͬʱ¸øFPGAËøÏ໷·¹©µçµÄ2.5V¡£ÔÚËøÏà»·Òý½ÅÉÏÎÒ½ÓÓÐ0.01uFµÄµçÈÝ£¬¿ÉÒÔÏëÏóËüÄܹ»ÒƳý´óÔ¼100MHzÒÔÉϵÄÉäƵÄÜÁ¿£¬Òò´Ë¶ÔJTAGÏÂÔØ¿ÚµÄÆäÉÏÀ×÷ÓõÄVCCAÓ°Ïì²»´ó£¨JTAGÅäÖÃģʽµÄ´ø¿í²¢²»¸ß£©£¬0.01uFµÄµçÈݲ»¿ÉÄÜ¶Ô ......
ÏÂÃæ¸ø³öÁËʹÓÃC# ¿ª·¢µÄÒ»¸öѹËõACCESSÊý¾Ý¿âµÄ³ÌÐò
ÏñFolderBrowserDialog£¨ÓÃÓÚä¯ÀÀÑ¡ÔñÎļþ¼ÐµÄ¶Ô»°¿ò£©¡¢MessageBox£¨ÏûÏ¢´¦Àí¶Ô»°¿ò£©¡¢DirectoryInfo£¨Ä¿Â¼ÐÅÏ¢£¬¿ÉÓÃÓÚ´´½¨¡¢¼ì²âÊÇ·ñ´æÔڵȶÔĿ¼µÄ²Ù×÷£©¡¢FileInfo£¨ÎļþÐÅÏ¢£¬¿ÉÓÃÓÚÎļþµÄ¼ì²â¡¢ÎļþÐÅÏ¢µÄ»ñÈ¡¡¢¸´ÖƵȲÙ×÷£©¡¢DataGridView£¨Êý¾Ý±í¸ñ¿Ø¼þ£¬ÓÃÓ ......
http://www.tongyi.net/article/20031101/200311013786.shtml
ËùνµÄÊý¾Ý´«Ê䣬ÆäʵÊÇÖ¸SQLServer·ÃÎÊAccess¡¢Excel¼äµÄÊý¾Ý¡£
ΪʲôҪ¿¼Âǵ½Õâ¸öÎÊÌâÄØ£¿
ÓÉÓÚÀúÊ·µÄÔÒò£¬¿Í»§ÒÔÇ°µÄÊý¾ÝºÜ¶à¶¼ÊÇÔÚ´æÈëÔÚÎı¾Êý¾Ý¿âÖУ¬ÈçAcess¡¢Excel¡¢Foxpro¡£ÏÖÔÚϵͳÉý¼¶¼°Êý¾Ý¿â·þÎñÆ÷ÈçSQLServer¡¢ORACLEºó£¬¾³£ÐèÒª·ÃÎÊÎı¾Êý ......
sqlserver£ºupdate Table_A set Table_A.col1 = (select Table_B.col1 from Table_B where Table_A.col2 = Table_B.col2)
Access: UPDATE Table_ A, Table_B SET Table_ A.×Ö¶Î2 = Table_ B.×Ö¶Î2
WHERE Table_ A.񅧏=Table_ A.񅧏;
×Ô¼º¼ÇÏ£¬ÌáÐÑ×Ô¼º ......