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

PL/SQL ÖеÄSQLÓï¾ä

ÀýÈ磺
ÆÕ±éµÄSQLÓï¾ä£º
          update book set bookname='sssss' where bookId=1;   
ÔÚPL/SQL ÖÐÖ´ÐУº 
          declare
           v_bookId number;
        begin
           v_bookId :=1;
           update book set bookname='sssss' where bookId=v_bookId;         
        end;
1£¬select
  ÔÚPL/SQL ³ÌÐòÖУ¬Ê¹ÓÃselect ...into Óï¾ä²éѯһ¸ö¼Ç¼µÄÐÅÏ¢£¬ÆäÓ﷨Ϊ£º
  select select_list_item into variable_list | record_variable from table where condition;
 ÀýÈ磺¸ù¾ÝÊéÃû»òÊéºÅ²éÕÒÊéµÄÐÅÏ¢¡£
declare
          v_bookId book.bookId%type;
          v_bookname book.bookname%type;
          v_table book%rowtype;
        begin
          select * into v_table from book where bookId=1;
          Dbms_Output.put_line('v_table.bookId '|| v_table.bookId || '  v_table.bookName ' || v_table.bookName);
          select bookId,bookName into v_bookId,v_bookname from book where bookId=1;
          Dbms_Output.put_line('v_bookId  '|| v_bookId || '  v_bookname  ' || v_bookname);
        end;
×¢Ò⣺
 select ...intoÓï¾äÖ»Äܲéѯһ¸ö¼Ç¼µÄÐÅÏ¢£¬Èç¹ûûÓвéѯµ½ÈκÎÊý¾Ý£¬»á²úÉúNO_DATA_FOUNDÒì³££»Èç¹û²éѯµ½¶àÌõ¼Ç¼£¬Ôò»á²úÉúTOO_MANY_ROWÒì³£¡£
into ¾ä×ÓºóµÄ±äÁ¿ÓÃÓÚ½ÓÊÕ²éѯµÄ½á¹û£¬±äÁ¿µÄ¸öÊý£¬Ë


Ïà¹ØÎĵµ£º

Ãâ°²×°Oracle¿Í»§¶ËÈí¼þ ʹÓÃpl/sqlÅäÖõǽ

ËäÈ»ÕâÊÇÎÒÕÒµ½×îÏêϸµÄÅäÖÃÃèÊö£¬µ«Êdz¢ÊÔ»¹ÊÇûÓгɹ¦¡£
 
1.ÏÂÔØOracle Client Package
.
´Ó
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
ÏÂÔØ
Instant
Client Package – Basic
°ü
(

±ê×¢
:All files
required to run OCI, OCCI, and JDBC-OC ......

ÔÚlinuxÉÏÅäÖÃunixODBCºÍFreeTDS·ÃÎÊMS SQL Server.

Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓÐ¶ÔÆäËü° ......

һЩ¼òµ¥µÄSQLÓï¾ä×ܼÆ

--------¼ì²âÊý¾Ý¿âÊÇ·ñ´æÔÚ
use master
go
if exists(select * from sysdatabases where name='DBName')
drop database DBName
-----´´½¨Êý¾Ý¿â
create database DBName
on
(
 /*Êý¾ÝÎļþµÄ¾ßÌåÃèÊö*/
 name='DBName_data', -----Ö÷Êý¾ÝÎļþµÄÂß¼­Ãû³Æ
 filename='D:\project\DBName_data.mdf', ......

ʹÓÃSQLÓï¾äÉú³ÉÊý¾Ý×Öµä

--sqlserver 2000
SELECT ±íÃû=case when a.colorder=1 then d.name else '' end,
--×Ö¶ÎÐòºÅ=a.colorder,
×Ö¶ÎÃû=a.name,
--
±êʶ=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,
/**/
Ö÷¼ü=case when exists(SELECT 1 from sysobjects where xtype='PK' and name
in ( ......

sqlÓï¾äѧϰ±Ê¼Ç(5) sqlÓï·¨

1.sqlÊÇÒ»Öֽű¾ÓïÑÔ
2.sql¿Éд½Å±¾³ÌÐò£¬µ«×îÖØÒªµÄ×÷Ó÷¢»ÓÔÚ¶ÔÊý¾Ý¿âµÄ²Ù×÷ÉÏ
3.sql server2005ÖеÄ×¢ÊÍÓÐÁ½ÖÖ/***/¶àÐÐ×¢ÊÍ£¬--¿ÉÒÔµ¥ÐÐ×¢ÊÍ
4.sqlÖеÄ×Ô¶¨Òå±äÁ¿ÒÔ@¿ªÍ·£¬ÏµÍ³±äÁ¿ÒÔ@@¿ªÍ·
5.sqlÖÐÉùÃ÷±äÁ¿ºÍVBÀàËÆ£¬Ê¹ÓÃdeclareÉùÃ÷±äÁ¿È磺declare @i int,@j int£¬´ËÓï¾äÉùÃ÷ÁË2¸öÕûÐαäÁ¿@iºÍ@j
6.sqlÖеÄÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ