Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ¾ä×ÓºóµÄ±äÁ¿ÓÃÓÚ½ÓÊÕ²éѯµÄ½á¹û£¬±äÁ¿µÄ¸öÊý£¬Ë


Ïà¹ØÎĵµ£º

sql¸ñʽ»¯ÈÕÆÚ

Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2010 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06
Select CONVERT(varch ......

SQL½Å±¾Ð޸ıí½á¹¹

н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] datetime,
[×Ö¶Î4] money null ,
[×Ö¶Î5] int default 0,
[×Ö¶Î6] Decimal (12,4) default 0,
[×Ö¶Î7] image null ,
)
ɾ³ý±í£º
Drop table [±í ......

SQL Server 2005 Á¬½Ó×Ö·û´®

Ô­ÎÄת×Ô http://blog.csdn.net/jyh_jack/archive/2008/04/07/2257512.aspx
SQL Native Client ODBC Driver
 
±ê×¼°²È«Á¬½Ó
   
Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
 
ÄúÊÇ·ñÔÚʹÓÃSQL Server 2005 Express£¿ Çë ......

³õѧPL/SQLµÄһЩ»ù±¾ÖªÊ¶

 1,Ò»¸öÍêÕûµÄPL/SQL Óï¾äÓÉÈý¸ö²¿·Ö×é³É¡£
             declare
                   ÉùÃ÷²¿·Ö£¬¶¨Òå±äÁ¿£¬Êý¾ÝÀàÐÍ£¬Òì³££¬¾Ö²¿×Ó³ÌÐòµÈ¡£
 &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ