ÖØÐ±àÒëËùÓÐÎÞЧµÄPL/SQLÄ£¿é£¨¶ÔÏó£©
µ±OracleÊý¾Ý¿â´´½¨Íê³Éºó£¬ÏµÍ³½«»á×Ô¶¯ÔËÐÐutlrp.sqlÕâ¸ö½Å±¾Îļþ£¨D:\oracle\product\10.1.0\Db_1\RDBMS\ADMIN£©£¬µ«ÊÇ£¬µ±Í¨¹ý¶¨Öư²×°ÀàÐ͵ķ½Ê½´´½¨ÁËÊý¾Ý¿âʱ£¬ÏµÍ³Ôò²»»áÔËÐÐutlrp.sqlÕâ¸ö½Å±¾£¬ËùÒÔ£¬½¨ÒéÔÚ´´½¨¡¢¸üлòÇ¨ÒÆÒ»¸öÊý¾Ý¿âºó£¬ÔËÐÐÒ»ÏÂutlrp.sqlÕâ¸ö½Å±¾£¬ÒÔÑéÖ¤Êý¾Ý¿â°²×°ÊÇ·ñ³É¹¦£¬ÕâÑù¿ÉÒÔÖØÐ±àÒëËùÓпÉÄÜ´¦ÓÚÎÞЧµÄPL/SQLÄ£¿é£¨°ü¡¢´æ´¢¹ý³Ì¡¢ÀàÐÍ¡¢º¯ÊýµÈµÈ£©£¬Õâ¸ö²½ÖèÊÇ¿ÉÑ¡µÄ£¬µ«ÊÇÍÆ¼ö¸Ã²½Öè¡£×¢Ò⣺ÔÚÔËÐиýű¾ÆÚ¼ä£¬Êý¾Ý¿âÖв»ÔÊÐíÓÐÆäËüµÄÊý¾Ý¿â¶¨ÒåÓïÑÔ£¨DDL£©ÔËÐв¢±£Ö¤STANDARDºÍDBMS_STANDARDÁ½¸ö°ü´¦ÓÚÓÐЧ״̬¡£
²½Ö裺
1£©Æô¶¯SQL*PLUS²¢ÒÔDBA½ÇÉ«µÄÕË»§Á¬½Óµ½Êý¾Ý¿â
SQL>sqlplus /nolog
SQL>conn lijing/lijing as sysdba
SQL>@D:\oracle\product\10.1.0\Db_1\RDBMS\ADMIN\utlrp.sql
Ïà¹ØÎĵµ£º
Sql´úÂë
--²ÉÓÃSQLÓï¾äʵÏÖsql2005ºÍExcel Êý¾ÝÖ®¼äµÄÊý¾Ýµ¼Èëµ¼³ö£¬ÔÚÍøÉÏÕÒÀ´Ò»--Ï£¬ÊµÏÖ·½·¨ÊÇÕâÑùµÄ£º
--Excel---->SQL2005 µ¼È룺
select * into useinfo from O ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
SQL Server 2005 Êý¾ÝÀàÐÍ
´´½¨Êý¾Ý¿â±íʱ£¬±ØÐëΪ±íÖеÄÿÁзÖÅäÒ»ÖÖÊý¾ÝÀàÐÍ¡£
1. ×Ö·û´®ÀàÐÍ
×Ö·û´®ÀàÐͰüÀ¨varchar,char,nvarchar,nchar,textºÍntext.ÕâЩÊý¾ÝÀàÐÍÓÃÓÚ´æ´¢×Ö·ûÊý¾Ý¡£VarcharºÍcharÀàÐÍÖ®¼äµÄ²î±ðÊÇÊý¾ÝÌî³ä¡£Èç¹ûÒª½ÚÊ¡¿Õ¼ä£¬ÎªÊ²Ã´ÓÐʱºò»¹Ê¹ÓÃcharÊý¾ÝÀàÐÍÄØ ......
±ístuinfo£¬ÓÐÈý¸ö×Ö¶Îrecno(×ÔÔö),stuid,stuname
½¨¸Ã±íµÄSqlÓï¾äÈçÏ£º
CREATE TABLE [StuInfo] (
[recno] [int] IDENTITY (1, 1) NOT NULL ,
[stuid] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[stuname] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO
1.--²éijһÁ ......
/// <summary>
/// ·µ»Ø·ÖÒ³SQLÓï¾ä
/// </summary>
/// <param name="selectSql">²éѯSQLÓï¾ä</param>
/// ......