[SQL Server] ´æ´¢¹ý³ÌÊÂÎñ
ÔÚ´æ´¢¹ý³ÌÖÐʹÓÃÊÂÎñ£¬ÒÔÏÂΪģ°å£º
CREATE PROCEDURE testPro
AS
/**//* ------- ÊÂÎñ¿ªÊ¼---------- */
BEGIN TRANSACTION tran_test
/**//* -------- ±£´æÊÂÎñ----------*/
SAVE TRANSACTION tran_test
/**//* -------- Êý¾Ý²Ù×÷---------*/
INSERT [table1] ( [content] ) VALUES ( '43332' )
/**//*---------- Ìá½»ÊÂÎñ------------*/
COMMIT TRANSACTION tran_test
/**//*--------- ÅжÏÊÇ·ñÓдíÎó----------*/
IF ( @@ERROR <> 0 )
BEGIN
/**//*---------- ×Ô¶¨Òå´íÎóÊä³ö----------*/
RAISERROR( 'Insert data error!',16,1 )
/**//*-------- ÊÂÎñ»Ø¹ö--------*/
ROLLBACK TRANSACTION tran_test
END
/**//*------- ÅжÏÊÂÎñÊýÊÇ·ñ´óÓÚ-----------*/
IF ( @@TRANCOUNT > 0 )
BEGIN
/**//*-------- ÊÂÎñ»Ø¹ö--------*/
ROLLBACK TRANSACTION tran_test
END
GO
Ïà¹ØÎĵµ£º
1ʹÓò»´ø²ÎÊýµÄ´æ´¢¹ý³Ì
¡¡¡¡Ê¹Óà JDBC Çý¶¯³ÌÐòµ÷Óò»´ø²ÎÊýµÄ´æ´¢¹ý³Ìʱ£¬±ØÐëʹÓà call SQL תÒåÐòÁС£²»´ø²ÎÊýµÄ call תÒåÐòÁеÄÓï·¨ÈçÏÂËùʾ£º
¡¡¡¡
ÒÔÏÂÊÇÒýÓÃƬ¶Î£º
{call procedure-name}
¡¡¡¡×÷ΪʵÀý£¬ÔÚ SQL Server 2005 AdventureWorks ʾÀýÊý¾Ý¿âÖд´½¨ÒÔÏ´洢¹ý³Ì£º
¡¡¡¡
ÒÔÏÂÊÇÒýÓÃƬ¶Î£º
......
1.
select top m * from tablename where id not in (select top n id from tablename)
2.
select top & ......
ÔÚ Oracle 10g ÖÐ
¿ÉÒÔͨ¹ý http://localhost:5560/isqlplus ·ÃÎÊ isqlplus
ÔÚ isqlplus ÖÐ ¿ÉÒÔÖ´ÐÐ plsql
set serveroutput on size 100000 // ´ò¿ª ·þÎñÆ÷µÄÊä³ö on ºóÃæÊÇ »º´æµÄ´óС ·¶Î§ÊÇ (2000 ÖÁ 1000000)
begin
dbms_output.put_line('hel ......
Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃÐ ......
ORACLEÖÐ×ֶεÄÊý¾ÝÀàÐÍ
×Ö·ûÐÍ char ·¶Î§ ×î´ó2000¸ö×Ö½Ú ¶¨³¤
char(10) 'ÕÅÈý' ºóÌí¿Õ¸ñ6¸ö°Ñ10¸ö×Ö½Ú²¹Âú 'ÕÅÈý &nb ......