PL/SQL¼¯½õ
--ÉèÖÃÊý¾Ý¿âÊä³ö£¬Ä¬ÈÏΪ¹Ø±Õ£¬Ã¿´Îдò¿ª´°¿Ú¶¼ÒªÖØÐÂÉèÖÃ
set serveroutput on
--µ÷Óà °ü º¯Êý ²ÎÊý
execute dbms_output.put_line('hello world');
--»òÕßÓÃcallµ÷Óã¬Ï൱ÓÚjavaÖеĵ÷ÊÔ³ÌÐò´ò×®
call dbms_output.put_line('hello world');
--plÓï¾ä¿éÊÇpl/sqlÀï×îСµÄ±à³Ì¿é£¬ÆäÖпÉÒÔÔÙǶÌ×begin end
begin
dbms_output.put_line('Hello World');
dbms_output.put_line('2*3='||(2*3));
dbms_output.put_line('what''s');
end;
--ÈçºÎÉùÃ÷±äÁ¿£¬ËùÓбäÁ¿±ØÐëÔÙdeclareÖÐÉùÃ÷£¬³ÌÐòÖв»ÔÊÐíÉùÃ÷
--ûÓгõʼ»¯µÄ±äÁ¿Ä¬ÈÏֵΪnull£¬ÆÁÄ»ÉÏnullÊÇ¿´²»¼ûµÄ£¬ÃüÃûÏ°¹ß£ºÒ»°ã±äÁ¿ÒÔv_¿ªÍ·
--×¢ÒânumberÒ²ÄÜ´æСÊý£¬×38룬ËùÒÔÒÔºó½¨ÒéÕûÊý¶¼ÓÃbinary_integer´æ
--longÊÇ×Ö·ûÀàÐÍ£¬booleanÀàÐͲ¹ÄÜ´òÓ¡
--±ê×¼±äÁ¿ÀàÐÍ£ºÊý×Ö£¬×Ö·û£¬Ê±¼ä£¬²¼¶û
declare
v_number1 number ;
v_number2 number(3,2) ;
v_number3 binary_integer :=1;
v_name varchar2(20) :='kettas';
v_date date :=sysdate;
v_long long :='ni hao';
v_b boolean := true;
begin
if (v_number1 is null) then
dbms_output.put_line( 'hello');
end if;
dbms_output.put_line(v_number1);
dbms_output.put_line(v_number2);
dbms_output.put_line(v_number3);
dbms_output.put_line(v_name);
dbms_output.put_line(v_date);
dbms_output.put_line(v_long);
--dbms_output.put_line(v_b);
end;
/
--×éºÏÀàÐÍ£ºrecord table
--recordÀàÐÍ×î³£Óã¬ÉùÃ÷µÄʱºò¿ÉÒÔ¼Ónot null£¬µ«±ØÐë¸ø³õʼֵ
--Èç¹ûrecordÀàÐÍÒ»Ö¿ÉÒÔÏ໥¸³Öµ£¬Èç¹ûÀàÐͲ»Í¬£¬ÀïÃæµÄ×Ö¶ÎÇ¡ºÃÏàͬ£¬²»ÄÜ»¥Ïำֵ
declare
type t_first is record(
id number(3),
name varchar2(20)
);
v_first t_first;
begin
v_first.
Ïà¹ØÎĵµ£º
´¥·¢Æ÷ÊÇÒ»ÖÖÌØÊâµÄ´æ´¢¹ý³Ì£¬ÀàËÆÓÚʼþº¯Êý£¬SQL Server™ ÔÊÐíΪ Insert¡¢Update¡¢Delete ´´½¨´¥·¢Æ÷£¬¼´µ±ÔÚ±íÖвåÈë¡¢¸üС¢É¾³ý¼Ç¼ʱ£¬´¥·¢Ò»¸ö»òһϵÁÐ T-SQLÓï¾ä¡£
´¥·¢Æ÷¿ÉÒÔÔÚ²éѯ·ÖÎöÆ÷Àï´´½¨£¬Ò²¿ÉÒÔÔÚ±íÃûÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”À´´´½¨£¬²»¹ý¶¼ÊÇҪд T-SQL ......
1.Óòéѯ·ÖÎöÆ÷ÖØÃüÃû
exec sp_rename ÔÃû³Æ, ÐÂÃû³Æ
sp_rename ÊÇ SQL Server™ ×Ô´øµÄÒ»¸ö´æ´¢¹ý³Ì£¬ÓÃÓÚ¸ü¸Äµ±Ç°Êý¾Ý¿âÖÐÓû§´´½¨µÄ¶ÔÏóµÄÃû³Æ£¬Èç±íÃû¡¢ÁÐ±í¡¢Ë÷ÒýÃûµÈ¡£
2.ÓÃÆóÒµ¹ÜÀíÆ÷ÖØÃüÃû
ÔÚ±íÉϵãÓÒ¼ü->“ËùÓÐÈÎÎñ”->“¹ÜÀí´¥·¢Æ÷”£¬Ñ¡ÖÐËùÒªÖØÃüÃûµÄ´¥·¢Æ÷£¬Ð޸Ĵ¥·¢Æ÷ ......
SQL:
using System.Data.SqlClient;
string sql = "server=.;uid=sa;pwd=;database=tablename;";
ACCESS:
using System.Data.OleDb;
string sql = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=" + HttpRuntime.AppDomainAppPath + "//App_Data//db.mdb";
HttpRuntime.AppDomainAppPath Ϊ¸ùĿ¼
......
1.²éÕÒÖظ´Êý¾Ý±íµÄidÒÔ¼°Öظ´Êý¾ÝµÄÌõÊý
select max(id) as nid,count(id) as Öظ´ÌõÊý from tableName
group by linkname Having Count(*) > 1
2.²éÕÒÖظ´Êý¾Ý±íµÄÖ÷¼ü
select max(id) as nid from tableName
group by linkname Having Count(id) > 1
3.ɾ³ýÖظ´µÄÊý¾Ý
delete from table ......
¹ØÓÚSQL Prompt
µÄÆƽâÎÄÕÂÔ°×ÓÀïÒѾÓв»ÉÙÈË·¢¹ýÁË¡£Æƽâ˼·ÎÒÒ²²»ÏëÖظ´£¬²»ÖªµÀµÄ¿ÉÒԲο¼£ºhttp://www.cnblogs.com/jintan/archive/2008/06/16/1223282.html
¹Ù·½ÏÂÔصØÖ·ÊÇ£ºhttp://downloads.red-gate.com/SQLToolbelt.exe
½ÓÏÂÀ´ÎÒ¾Í˵˵¾ßÌåÔõô×ö°É¡£ÎÒ¾Í˵˵×î¼òµ¥×îɵ¹ÏµÄ×ö·¨£¬²»ÐèÒª¶®ILÕÕÑùÆƽ⣡
× ......