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://topic.csdn.net/t/20050110/09/3711952.html
accessÖÐʱ¼äÒªÓÃ#,²»ÊÇË«ÒýºÅ
select * from kc where rq < #2000-01-01# and rq>#2002-01-01#
²»ÒªÓÃbetween,ËüµÄЧÂÊÌ©µÍ
ʹÓÃ# ¶ø²»ÊÇ ......
JDBCÁ¬½ÓMySQL
¼ÓÔؼ°×¢²áJDBCÇý¶¯³ÌÐò
Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
JDBC URL ¶¨ÒåÇý¶¯³ÌÐòÓëÊý¾ÝÔ´Ö®¼äµÄÁ¬½Ó
±ê×¼Óï·¨£º
<protocol£¨Ö÷ҪͨѶÐÒ飩>:<subprotocol£¨´ÎҪͨѶÐÒ飬¼´Çý¶¯³ÌÐòÃû³Æ£©>:<da ......
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Ϊµ ......
ÏÂÃæ¸ø³öÁËʹÓÃC# ¿ª·¢µÄÒ»¸öѹËõACCESSÊý¾Ý¿âµÄ³ÌÐò
ÏñFolderBrowserDialog£¨ÓÃÓÚä¯ÀÀÑ¡ÔñÎļþ¼ÐµÄ¶Ô»°¿ò£©¡¢MessageBox£¨ÏûÏ¢´¦Àí¶Ô»°¿ò£©¡¢DirectoryInfo£¨Ä¿Â¼ÐÅÏ¢£¬¿ÉÓÃÓÚ´´½¨¡¢¼ì²âÊÇ·ñ´æÔڵȶÔĿ¼µÄ²Ù×÷£©¡¢FileInfo£¨ÎļþÐÅÏ¢£¬¿ÉÓÃÓÚÎļþµÄ¼ì²â¡¢ÎļþÐÅÏ¢µÄ»ñÈ¡¡¢¸´ÖƵȲÙ×÷£©¡¢DataGridView£¨Êý¾Ý±í¸ñ¿Ø¼þ£¬ÓÃÓ ......
Ò»¡¢´´½¨Ò»ÕÅ¿Õ±í£º
Sql="Create TABLE [±íÃû]"
¶þ¡¢´´½¨Ò»ÕÅÓÐ×Ö¶ÎµÄ±í£º
Sql="Create TABLE [±íÃû]([×Ö¶ÎÃû1] MEMO NOT NULL, [×Ö¶ÎÃû2] MEMO, [×Ö¶ÎÃû3] COUNTER NOT NULL, [×Ö¶ÎÃû4] DATETIME, [×Ö¶ÎÃû5] TEXT(200), [×Ö¶ÎÃû6] TEXT(200))
×Ö¶ÎÀàÐÍ£º
2 : "SmallInt", // ÕûÐÍ
3 : "Int", ......