Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql 2000 ¸´ÖƱí

SQLÓï¾äʵÏÖ£¬SQL Server 2000 ¼°ACCESS¸´ÖƾɱíOldTableµÄ½á¹¹£¬»ò½á¹¹¼°ÄÚÈݵ½ÐµıíNewTable
Á½¸ö¶¼ÊÔ¹ýÁË£¬ÏÂÃæµÄ´úÂëÔÚÕâÁ½¸öÊý¾Ý¿âÖУ¨SQL Server 2000 ¼°ACCESS£©¶¼ÊÇ¿ÉÒÔͨ¹ýµÄ¡£
--¸´ÖƱí½á¹¹ÎªÐµıí
select * into NewTable
from OldTable where 1=2
--¸´ÖƱí½á¹¹¼°ÄÚÈݵ½Ðµıí
select * into newtable
from oldtable
Èç¹ûÄúÖ»ÐèÒª¾É±íµÄ»òÒÔǰ±íµÄijһЩ×ֶΣ¬»ò»ã×ܺóµÄÄÚÈݺϳÉÒ»¸ö×ֶεϰ£¬¿ÉÒÔÕâÑù
--¸´ÖƱí½á¹¹ÄÚµÄijЩ×Ö¶ÎΪеıí
select title,type,price,notes ok into NewTable2
from titles where 1=2
--¸´ÖƱí½á¹¹¼°ÄÚÈݵ½ÐÂµÄ±í£¬¿ÉÒÔÑ¡Ôñ×Ö¶Î
select title,type,price,pub_id-price ok into NewTable2
from titles
ÄúÒ²¿ÉÒÔÕâÑù,Ïȸ´ÖƱí½á¹¹£¨¿ÉÒÔѡһЩ×Ö¶ÎΪÐÂµÄ±í£©£¬ÔÙ²åÈëÄÚÈÝ
--¸´ÖƱí½á¹¹ÄÚµÄijЩ×Ö¶ÎΪеıí
select title y1,type y2,price y3 into yongfa365
from titles where 1=2
--ÏòеıíÀïÌí¼ÓÊý¾Ý
insert into yongfa365 (y1,y2,y3) select title,type,price from titles
Æäʵ£¬Í¨¹ýÒÔÉϵÄÀý×Ó´ó¼Ò¿ÉÒÔ¿´µ½£¬ÎÞÂÛÊǸ´ÖƱí½á¹¹»¹ÊÇÄÚÈÝ£¬»¹ÊÇ»ã×ܵĽá¹û¶¼¿ÉÒÔµ½Ò»¸öеıíÀï£¬ÎªÊ²Ã´ÄØ£¬ÕâʱÎÒÏëÆðÁË£¬¿ÉÒÔ°Ñ
(select * from
table)µ±³ÉÒ»¸ö±í£¬ÄÇÕâ¸öÎÊÌâ¾ÍÓдð°¸ÁË£º¼ÈÈ»¿ÉÒÔ°ÑÑ¡Ôñ½á¹ûµ±³ÉÒ»¸ö±í£¬ÄÇÕâ¸ö±í¾Í¿ÉÒÔ±£´æÏÂÀ´ÁË£¬Ö±½Ó±£´æ³ÉÒ»¸öÕæÕýµÄ±í£¬¹©ÒÔºóʹÓÃÁË¡£
Äú¿ÉÒÔ°ÑÉÏÃæµÄ»ÆÉ«×ÖÌåÈ¥µô£¬´úÂ뻹ÊÇÒ»Ñù¿ÉÒÔÔËÐеġ£


Ïà¹ØÎĵµ£º

SQL ServerÖд洢¹ý³ÌÓ뺯ÊýµÄÇø±ð

SQL ServerÓû§×Ô¶¨Ò庯ÊýºÍ´æ´¢¹ý³ÌÓÐÀàËÆµÄ¹¦ÄÜ£¬¶¼¿ÉÒÔ´´½¨À¦°óSQLÓï¾ä£¬´æ´¢ÔÚserverÖй©ÒÔºóʹÓá£ÕâÑùÄܹ»¼«´óµØÌá¸ß¹¤×÷ЧÂÊ£¬Í¨¹ýÒÔϵĸ÷ÖÖ×ö·¨¿ÉÒÔ¼õÉÙ±à³ÌËùÐèµÄʱ¼ä£º
¡¡¡¡ 1 ÖØ¸´Ê¹Óñà³Ì´úÂ룬¼õÉÙ±à³Ì¿ª·¢Ê±¼ä¡£
¡¡¡¡ 2 Òþ²ØSQLϸ½Ú£¬°ÑSQL·±ËöµÄ¹¤×÷Áô¸øÊý¾Ý¿â¿ª·¢ÈËÔ±£¬¶ø³ÌÐò¿ª·¢Ô±Ôò¼¯Öд¦Àí¸ß¼¶±à³Ì ......

PL/SQL 001

ÔÚ Oracle 10g  ÖР
¿ÉÒÔͨ¹ý http://localhost:5560/isqlplus ·ÃÎÊ isqlplus 
ÔÚ isqlplus ÖÐ ¿ÉÒÔÖ´ÐÐ plsql
set serveroutput on size 100000   // ´ò¿ª ·þÎñÆ÷µÄÊä³ö  on ºóÃæÊÇ »º´æµÄ´óС ·¶Î§ÊÇ  (2000 ÖÁ 1000000)
begin
   dbms_output.put_line('hel ......

ÓÃSQLÓï¾ä´Óaspnet_profile±íÀïÈ¡Óû§µÄProfileÖµ

The aspnet_Profile table contains the following fields: UserId, PropertyNames, PropertyValuesString, PropertyValuesBinary,  and LastUpdatedDate. The PropertyNames field contains a string delimited with colons (:) that identify which profile fields are stored, what their datatype is and their of ......

SQL 2008 ½Ø¶ÏÊÂÎñÈÕÖ¾²»ÄÜÓÃÁË£¿£¿

BACKUP DATABASENAME WITH NO_LOGÒ»Ö±ÊÇÎҽضÏÊÂÎñÈÕÖ¾£¬Ñ¹Ëõ¿Õ¼äµÄÀûÆ÷£¬½ñÌìÔÙSQL2008ÉÏÒ»Óã¬È´²»ÁéÁË
ÏûÏ¢ 3032£¬¼¶±ð 16£¬×´Ì¬ 2£¬µÚ 2 ÐÐ
´ËÓï¾ä²»Ö§³ÖÒ»¸ö»ò¶à¸öÑ¡Ïî(no_log)¡£Çë²éÔÄÎĵµÒÔÁ˽âËùÖ§³ÖµÄÑ¡Ïî¡£
²é¿´Áª»ú°ïÖúÊֲᣬÀïÃæÈ·ÊµÃ»ÓÐwith no_logµÄ¿ÉÑ¡ÏîÁË£¬ÄÇÔõô°ì°¡£¬50MµÄÊý¾ÝÎļþ£¬2GµÄÈÕÖ¾Îļþ£¬È ......

PL/SQLѧϰ±Ê¼Ç


1£®SQL²¢Ðвéѯ
alter session enable parallel dml execute immediate 'alter session enable parallel dml'; --Ð޸ĻỰ²¢ÐÐDML      select /*+parallel(a,4)*/ * from table_name a       select /*+parallel(a,8)*/ * from table_name a    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ