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Á¬½Ó²éѯºÍÁªºÏ²éѯ
Á¬½Ó²éѯ
ͨ¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØÏµÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌØµã£¬Ò²ÊÇËüÇø±ðÓÚÆäËüÀàÐÍÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£
ÔÚ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹ØÏµ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚÒ»¸ö±íÖС£µ±¼ìË÷Êý¾Ýʱ£¬Í¨¹ýÁ¬½Ó²Ù×÷² ......
¹Ì¶¨·þÎñÆ÷½ÇÉ«
sysadmin ¿ÉÒÔÔÚ SQL Server ÖÐÖ´ÐÐÈκλ¡£
serveradmin ¿ÉÒÔÉèÖ÷þÎñÆ÷·¶Î§µÄÅäÖÃÑ¡Ï¹Ø±Õ·þÎñÆ÷¡£
setupadmin ¿ÉÒÔ¹ÜÀíÁ´½Ó·þÎñÆ÷ºÍÆô¶¯¹ý³Ì¡£
securityadmin ¿ÉÒÔ¹ÜÀíµÇ¼ºÍ CREATE DATABASE ȨÏÞ£¬»¹¿ÉÒÔ¶ÁÈ¡´íÎóÈÕÖ¾ºÍ¸ü¸ÄÃÜÂë¡£
processadmin ¿ÉÒÔ¹ÜÀíÔÚ SQL Server ÖÐÔËÐеĽø³Ì¡£
......
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 ......
ÔÎÄת×Ô 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£¿ Çë ......