ÔÚSQLÖУ¬ÕâÑùдÊǵ±tbTest±í´æÔÚʱ£¬É¾³ý±íÔÙ´´½¨±í£¬²»´æÔÚʱ£¬Ö±½Ó´´½¨
SQL code:
if object_id('tbTest') is not null drop table tbTest
create table tbTest
(
)
ÔÚACCESSÖÐÔõôд£¿Ð»Ð»£¡
ÒýÓÃ
ûÓÐÏàÀàËÆµÄSQLÓï¾ä£¬ÔÚ³ÌÐòÖв¶»ñ´íÎó
лл¡£
ÄÇÊDz»ÊÇ˵ÎÒÏëÒªµÄÕâÖÖЧ¹û´ï² ......
windows 2003,ÔÚC:\windowsµÄĿ¼ÉÏ
ÓÒ¼ü-->°²È«-->¸ß¼¶-->Ë«»÷users×é-->°Ñ"ÁгöÎļþ¼Ð/¶ÁÈ¡Êý¾Ý"ÉϵĹ´È¥µô-->È·¶¨
Ò²¾ÍÊÇÈ¥µôwindowsĿ¼µÄÁгöÕâ¸öÎļþ¼ÐϵÄÎļþ¼°Îļþ¼ÐµÄȨÏÞ(ÔÀ´µÄ¶ÁȨÏÞ»¹ÊÇÓеÄ)
¿ÉÊÇÍøÕ¾³ÌÐò·ÃÎÊaccessÊý¾Ý¿â¾Í±¨´íÁË,°Ñ¸Õ¸Õ×öµÄÉèÖÃÈ¥µ ......
ÄÄλ´óÏÀÖªµÀ±È½ÏºÃÓõÄasp+accessµÄ±È½ÏºÃÓõÄcms£¿
ÏÖÔÚ´ó¶àÊýµÄcms¶¼ÊÇmysqlµÄ£¬µ«ÊÇÓÉÓÚÊý¾Ý¿âÎÊÌâÖ»ÄÜÓÃaccess£¬¶øÇÒÊý¾ÝÁ¿²»´ó¡£ËùÒԾͲ»¿¼ÂÇsqlÁË¡£
×îºÃÄܹ»ºÜ¼ò½à¡£¡£¡£¡£
¶àлÀ²£¡£¡
http://www.acidcat.com/
ºÃÏñ¶ÔÖÐÎÄÖ§³ÖµÄ²»ºÃ°¡ »¹ÊÇÎÒµçÄÔµÄÎÊÌâ¡£¡£¡£¡£
......
ÈçÌâ
ÓÃQuery1->Parameters->Items[7]->LoadfromFile(ExtractFilePath ( ParamStr(0) )+"zp.bmp",ftBlob);´æÈëºó£¬¶Á³öÀ´µÄͼÏñÊDZäÐεġ£
ADOµÄ·½·¨£º
C/C++ code:
//===========================================================================
// ¶Á
TBlobField *pField = (TBlobField ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & mingchen & "555" & ".mdb")
tbl = New ADOX.Table
tbl.Name ......
ÓÐÒ»¸ö±íΪ£º
id name
-----------
1 xxx
2 111
3 xxx
4 333
ÒªÇó²é³öÀ´µÄ½á¹ûΪ£º
name
-----------
333
xxx
111
ÔõôʵÏÖ£¿£¿Çë½Ì¸ßÊÖ
jwdream2008
(ɽÖпÍ)
µÈ¡¡¼¶£º
#3Â¥ µÃ·Ö£º3»Ø¸´ÓÚ ......