Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PL/SQLѧϰ±Ê¼ÇÒ»


ʲôÊÇPL/SQL
PL/SQL(Procedural Language/SQL,¹ý³Ì»¯SQLÓïÑÔ£©ÊÇOracle¹«Ë¾ÔÚ±ê×¼SQLÓïÑԵĻù´¡ÉÏ·¢Õ¹µÄÓïÑÔ£¬Ëü½«±äÁ¿¡¢¿ØÖƽṹ¡¢¹ý³ÌºÍº¯ÊýµÈ½á¹¹»¯³ÌÐòÉè¼ÆµÄÒªËØÒýÈëSQLÓïÑÔ£¬´Ó¶øÄܹ»±àÖƱȽϸ´ÔÓµÄSQL³ÌÐò£»ÀûÓÃPL/SQLÓïÑÔ±àдµÄ³ÌÐò³ÆΪPL/SQL³ÌÐò¿é£¬ÆäÖ÷ÒªÌصãÈçÏ£º
¾ßÓÐÄ£¿é»¯µÄ½á¹¹
ʹÓùý³Ì»¯ÓïÑÔ¿ØÖƽṹ
Äܹ»½øÐдíÎó´¦Àí
PL/SQL³ÌÐò½á¹¹
ÍêÕûµÄPL/SQL³ÌÐò½á¹¹¿ÉÒÔ·Ö³É3¸ö²¿·Ö£º
¶¨Ò岿·Ö£ºÒÔdeclareΪ±êʶ£¬ËùÓгÌÐòÖÐʹÓõij£Á¿¡¢±äÁ¿¡¢ÓαꡢÀýÍâ´¦ÀíµÈ¶¼±ØÐëÔڸò¿·Ö¶¨Òå
Ö´Ðв¿·Ö£ºÒÔbeginΪ¿ªÊ¼±êʶ£¬ÒÔendΪ½áÊø±êʶ¡£´Ë²¿·Ö±ØÐë
Òì³£´¦Àí²¿·Ö£º¸Ã²¿·Ö°üº¬ÔÚÖ´Ðв¿·ÖÀïÃ棬ÒÔexceptionΪ±êʶ
×ÜÌå½á¹¹Ï£º
declare
     ¶¨ÒåÓï¾ä¶Î
begin
     Ö´ÐÐÓï¾ä¶Î
exception
     Òì³£´¦ÀíÓï¾ä¶Î
end


Ïà¹ØÎĵµ£º

SQLÓï¾ä²éѯÊÇ·ñΪ¿Õ =null¼°null

  a                  b                             c&nb ......

sql´æ´¢¹ý³Ì·ÖÒ³

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[pagination]
@tblName varchar(255), -- ±íÃû
@strGetFields varchar(1000), -- ÐèÒª·µ»ØµÄÁÐ
@fldName varchar(255), -- ÅÅÐòµÄ×Ö¶ÎÃû
@PageSize int, -- Ò³³ß´ç
@PageIndex int, -- Ò³Âë
@OrderType bit, -- ÉèÖÃÅÅÐòÀàÐÍ, ·Ç 0 Öµ ......

linq to sql ÖдÓdbmlÎļþÖд´½¨Êý¾Ý¿â

        ½ñÌìºÜÓôÃÆ,ʵÑéÊҵķþÎñÆ÷¶«Î÷¶¼Ã»ÓÐÁË,¶øÎÒµÄÊý¾Ý¿âÓÖÔÚÄÄÀï,ÎÒÓÖûÓб¸·Ý,°ÑÎÒÒÖÓôµÄÒªÃü,ÐÒ¿÷ÎÒÓõÄlinq to sql.×ÐϸÏëÏë,ËûµÄdbmlÎļþ»ù±¾°üº¬ÁËÊý¾Ý¿âµÄËùÓÐÄÚÈÝ,ËùÒÔ,Ò»¶¨Óа취´ÓdbmlÎļþÖд´½¨Êý¾Ý¿â!
        Ñо¿ÁËÒ»¶ÎÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ