Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Á¬½Ó²éѯºÍÁªºÏ²éѯ


SqlÁ¬½Ó²éѯºÍÁªºÏ²éѯ
Á¬½Ó²éѯ
   ͨ¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØÏµÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌØµã£¬Ò²ÊÇËüÇø±ðÓÚÆäËüÀàÐÍÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£
   ÔÚ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹ØÏµ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚÒ»¸ö±íÖС£µ±¼ìË÷Êý¾Ýʱ£¬Í¨¹ýÁ¬½Ó²Ù×÷² ......

SQL Server·þÎñÆ÷½ÇÉ«ÓëÊý¾Ý¿â½ÇÉ«Çø±ð

¹Ì¶¨·þÎñÆ÷½ÇÉ«
sysadmin ¿ÉÒÔÔÚ SQL Server ÖÐÖ´ÐÐÈκλ¡£
serveradmin ¿ÉÒÔÉèÖ÷þÎñÆ÷·¶Î§µÄÅäÖÃÑ¡Ï¹Ø±Õ·þÎñÆ÷¡£
setupadmin ¿ÉÒÔ¹ÜÀíÁ´½Ó·þÎñÆ÷ºÍÆô¶¯¹ý³Ì¡£
securityadmin ¿ÉÒÔ¹ÜÀíµÇ¼ºÍ CREATE DATABASE ȨÏÞ£¬»¹¿ÉÒÔ¶ÁÈ¡´íÎóÈÕÖ¾ºÍ¸ü¸ÄÃÜÂë¡£
processadmin ¿ÉÒÔ¹ÜÀíÔÚ SQL Server ÖÐÔËÐеĽø³Ì¡£
......

SqlÓï¾äѧϰ±Ê¼Ç(2) ´´½¨Êý¾Ý±í

use RetalDB--±íʾÔÚÊý¾Ý¿âRetalDBÖнøÐеIJÙ×÷
go
if exists (select * from sysobjects where name='tb_user')
 drop table tb_user
go
--´´½¨¿Í»§±ítb_user
create table tb_user
(
 user_id int primary key,--Ö¸¶¨ÎªÖ÷¼üʱ£¬´ËÁÐĬÈÏΪ·Ç¿Õ£¬Ö¸¶¨¹ý¶à¸öÏÞÖÆÌõ¼þʱ²»ÓÓ'”¸ô¿ª
 us ......

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£¿ Çë ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ