SQL ¿ª·¢ÈËÔ± Oracle Berkeley DB Ö¸ÄÏ£¨zz£©
×ªÔØÒ»¸öBDBµÄÏà¹Ø½éÉÜ£¬»ù±¾¿ÉÒÔµ±ËÙ³ÉÊÖ²áÓ㬸ü¶àµÄÎĵµ¿ÉÒÔÈ¥Oracle¹Ù·½ÍøÕ¾ÏÂÔØ¡£
SQL ¿ª·¢ÈËÔ± Oracle Berkeley DB Ö¸ÄÏ
×÷ÕߣºMargo Seltzer
Oracle Berkeley DB Öг£Óà SQL º¯ÊýʹÓÃÖ¸ÄÏ¡£
2007 Äê 9 Ô·¢±í
³£³£ÓÐÈËÎÊ Oracle Berkeley DB “ÎÒÈçºÎÔÚ Berkeley DB ÖнøÐÐ <SQL ²éѯ>£¿"Òò´Ë£¬ÎÒÃÇ´Ë´¦½«½éÉÜÈçºÎÔÚ Oracle Berkeley DB ÖÐʵʩÖÚ¶àÄúϲ°®µÄ SQL ¹¦ÄÜ¡£²»ÊÇËùÓÐµÄ SQL Ó¦ÓóÌÐò¶¼Ó¦¸ÃÔÚ Oracle Berkeley DB ʵʩ£¨ Oracle Berkeley DB ÊÇÒ»¸ö¿ª·ÅÔ´µÄǶÈëʽÊý¾Ý¿âÒýÇæ£¬ÌṩÁË¿ìËÙ¡¢¿É¿¿¡¢±¾µØµÄ³Ö¾ÃÐÔ£¬ÎÞÐè¹ÜÀí£©£¬µ«Èç¹ûÄúÓÐһϵÁÐÏà¶Ô¹Ì¶¨µÄ²éѯÇҺܹØÐÄÐÔÄÜ£¬Berkeley DB ½«ÊǺܺõÄÑ¡Ôñ¡£
ÈÃÎÒÃÇ´ÓÍ·¿ªÊ¼ (ºÜºÃµÄÆð²½µã)¡£ÎÒÃÇ´Ó ABC ¿ªÊ¼Ñ§ÔĶÁ£¬ÔÚ Berkeley DB ÖÐÎÒÃÇ´ÓÊõÓ↑ʼ¡£
ÕâÀïΪ¼á¶¨µÄ SQL ³ÌÐòÔ±ÌṩÁËÒ»¸öСÐÍ“·ÒëÖ¸ÄÏ”£º
SQL ÊõÓï
Oracle Berkeley DB ¶ÔÓ¦´Ê»ã
Êý¾Ý¿â
»·¾³
±í
Êý¾Ý¿â
×Ö½Ú×é/ÐÐ
¼ü/Êý¾Ý¶Ô
Ö÷Ë÷Òý
¼ü
´ÎË÷Òý
´ÎÊý¾Ý¿â
Ñ¡ÔñÒ»¸öÓ¦ÓóÌÐòÓò — ´«Í³Ô±¹¤Êý¾Ý¿â£¬¾¹ýÒ»¶¨µÄ¼ò»¯¡£ÎÒÃǽøÒ»²½¼Ù¶¨ÄúÐèÒªËùÓÐ Berkeley DB µÄÈ«²¿¶îÍâÌØÐÔ£º²¢·¢¡¢ÊÂÎñ¡¢¿É»Ö¸´ÐԵȡ£
´´½¨Êý¾Ý¿â
ÔÚ SQL ÖУ¬Äú¿ÉÒÔÖ´ÐÐÒÔÏÂÃüÁî
CREATE DATABASE personnel
ÔÚ Berkeley DB ÖÐ, ÄúÏëÒª´´½¨Ò»¸ö·ÅÖÃËùÓÐÓ¦ÓóÌÐòÊý¾ÝµÄ»·¾³¡£ÔÚ´úÂëÖУ¬Äú½«Í¨¹ýÒ»¸ö»·¾³¾ä±úÀ´ÒýÓû·¾³£¬¸Ã¾ä±úÀàÐÍΪ DB_ENV¡£Äú½«Ê¹ÓÃÕâÒ»¾ä±úÀ´²Ù×÷´Ë»·¾³¡£ÏÖÔÚ£¬½«Ò»Ð©¾«ÃîµÄ´íÎó´¦Àí¹ý³Ì·ÅÔÚÒ»±ß£¬À´¼¯ÖÐÌÖÂÛ API¡£
DB_ENV *dbenv;
int ret;
/* Create the handle. */
DB_ASSERT(db_env_create(&dbenv, 0) == 0);
/*
* If you wanted to configure the environment, you would do that here.
* Configuraition might include things like setting a cache size,
* specifying error handling functions, specifying (different)
* directories in which to place your log and/or data files, setting
* parameters to describe how many locks you'd need, etc.
*/
/* Now, open the handle. */
DB_ASSERT(dbenv->open(dbenv, "my_databases/personnel",
DB_CREATE | DB_INIT_LOCK | DB_INIT_MPOOL | DB_INIT_TXN | DB_THREAD, 0644);
ÄúÏÖÔÚ´´½¨ºÍ´ò¿ªÁËÒ»¸ö»·¾³¡£ÐèҪעÒ⼸ÏîÊÂÇ飺
¿ªÊ¼Ç°±ØÐëÓÐ my_databases/personnel Ŀ¼
Ïà¹ØÎĵµ£º
×ªÔØ£º
http://blog.sina.com.cn/s/blog_5f4ed9cb0100dza0.html
http://wowh.wuyan.org/2008/04/15/sqlserver-2k-system-error-126/
ÔÚ°²×°sql server ¾³£Óöµ½ÕâÑù¡¢ÄÇÑùµÄ´íÎ󣬽ñÌìÔÚËѵ½±È½ÏÈ«ÃæµÄ£¬¾ÍÌù³öÀ´£¬·ÖÏíÏ£¡
SQL
Server°²×°ÎÊÌâ´óÈ«
(2007-09-06
09:24:28)
±êÇ©£ºIT/¿Æ¼¼
Ò¼¡£WINDOWS XP ......
ALTER FUNCTION [dbo].[fun_tongji]()
RETURNS @t1 table (
yue int ,
money int
)
AS
begin
Declare @i int
set @i=1
-- declare @t1 table (
-- yue int ,
-- money int
-- )
while (@i<=12)&n ......
SQL Server Out Put Excel File
ÔÚ SQL ServerÖÐ, µ¼³öEXCEL Îļþ, Óõ½ bcp.exe
bcp µ¼³öµÄ±¾ÖÊÊÇ´¿Îı¾Îĵµ,
ÈôÊý¾Ýº¬ÓÐÖÐÎÄ,Çëµ¼³öµ½ÖÐÎİæEXCEL,»òTXTÎĵµµÈ, ·ñÔòÂÒÂë....
ÓÃTXT ´ò¿ªÓ¢ÎİæEXCEL,Ò²¿ÉÒÔ,
µ¼³ö Êý¾Ýµ½C:\authors.xls, ÈôÎļþ´æÔÚÔòÖØÐ´Îļþ, ²»´æÔÚÔò´´½¨Îļþ
  ......
²Ù×÷Êý¾Ý¿â¹ý³ÌÖУ¬Óöµ½Ðí¶àÎÊÌ⣬ºÜ¶à¶¼ÓëSQL CODEºÍSQL StateÏà¹Ø£¬ÏÖÔÚ°ÑÒ»¸öÍêÕûµÄSQLCODEºÍSQLState´íÎóÐÅÏ¢ºÍÏà¹Ø½âÊÍ×÷ÒÔÏÂ˵Ã÷£¬Ò»À´¿ÉÒÔ×Ô¼º²Î¿¼£¬¶ÔDB2´íÎó×ÔÐÐÕÒ³öÔÒò
£¨ÉùÃ÷£ºÕâÊÇËѼ¯ÍøÉϵÄ×ÊÁϵÃÀ´µÄ,Ïêϸ³ö´¦²»¼ÇµÃÁË£©
sqlcode sqlstate ˵Ã÷
000 00000 SQLÓï¾ä³É¹¦Íê³É
01xxx SQLÓï¾ä³É¹¦Íê³É£¬µ«ÊÇÓ ......