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 = '';
Ïà¹ØÎĵµ£º
ÉÏÍøgoogleÁËһϣ¬¿´Á˼¸¸öÈ˵ÄÌû×Ó£¬´ó¸ÅÃ÷°×ÁËÊÇʲôÒâ˼¡£
Èç¹ûÒ»¸öÓû§µÄIPÔÚ×î½üÒ»¶Îʱ¼äÄÚ¶à´ÎÓÉÓÚÃÜÂë´íÎóµÇ¼ʧ°Ü£¬ÄÇôϵͳ¾Í»á°ÑÕâ¸öÓû§·âµô£¬submit»òÕßmail¾Í»áÌáʾAccess denied.
Õâ±¾ÊÇÒ»¸ö°²È«´ëÊ©£¬µ«ÊÇûÏëµ½poj¿ªÍ¨ËùνµÄ"¹«Íø¼ÓËÙ"Ö®º ......
×òÍíÔÚ×öAccessÊý¾Ý¿â¿ª·¢Ê±Óöµ½Ò»¸ö¼òµ¥µÄÄ£ºý²éѯÎÊÌ⣬ÔÚaccess2007ÀïÃæ¿ÉÒÔ²é³öÀ´£¬µ«ÓÃC#2.0²éѯ¾ÍÊDz鲻³öÀ´¡£
ºóÀ´ÊÔ³öÀ´ÁË£¬ÔÀ´ ÊÇjetÓï·¨µÄÎÊÌ⣺
ÔÚAccessÖУ¬Ä£ºý²éѯÓà * ºÅ£¬Èç select * from T_PO where po_NO like '*8*'
µ«ÔÚC#³ÌÐòÀïÃæдµÄʱºòÒªÓà % ºÅ£¬¼´ select * from T_PO where po_NO like '%8% ......
ÏÂÃæ¸ø³öÁËʹÓÃC# ¿ª·¢µÄÒ»¸öѹËõACCESSÊý¾Ý¿âµÄ³ÌÐò
ÏñFolderBrowserDialog£¨ÓÃÓÚä¯ÀÀÑ¡ÔñÎļþ¼ÐµÄ¶Ô»°¿ò£©¡¢MessageBox£¨ÏûÏ¢´¦Àí¶Ô»°¿ò£©¡¢DirectoryInfo£¨Ä¿Â¼ÐÅÏ¢£¬¿ÉÓÃÓÚ´´½¨¡¢¼ì²âÊÇ·ñ´æÔڵȶÔĿ¼µÄ²Ù×÷£©¡¢FileInfo£¨ÎļþÐÅÏ¢£¬¿ÉÓÃÓÚÎļþµÄ¼ì²â¡¢ÎļþÐÅÏ¢µÄ»ñÈ¡¡¢¸´ÖƵȲÙ×÷£©¡¢DataGridView£¨Êý¾Ý±í¸ñ¿Ø¼þ£¬ÓÃÓ ......
C#ÖзÃÎʹؼü×Ö£¨access keyword£©ÓÐÁ½¸ö£ºbase¡¢this
1.base
ÓÃÓÚ´ÓÅÉÉúÀàÖзÃÎÊ»ùÀàµÄ³ÉÔ±£¬°üÀ¨£º
a.µ÷ÓûùÀàÉÏÒѱ»ÆäËü·½·¨ÖØд£¨override£©µÄ·½·¨¡£
b.Ö¸¶¨´´½¨ÅÉÉúÀàʵÀýʱӦµ÷ÓõĻùÀ๹Ô캯Êý¡£
×¢Ò⣺¶Ô»ùÀàµÄ·ÃÎÊÖ»ÄÜ ......
н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......