¼±ÇóÖúSqlserver´æ´í¹ý³Ì
CREATE PROCEDURE [dbo].[getNews]
@News_subject nvarchar(1000) =null,
@News_content nvarchar(max) =null,
@type int,
@FileName varchar(255) =null,
@descriptions nvarchar(1000) =null,
@News_sources nvarchar(1000) =null,
@News_clicks int,
@News_author nvarchar(1000) =null,
@News_addtime datetime,
@show int,
@Thumbnail varchar(255) =null,
@width int,
@height int,
@titleColor varchar(255) =null,
@keywords nvarchar(1000) =null,
@News_ID int
AS
set nocount on
begin
If @News_ID is Null Return
Select @News_subject=News_subject,@News_content=News_content,@type=type,@FileName=Filename,@descriptions=description,@News_sources=News_Sources,@News_clicks=News_clicks,@News_author=News_author,@News_addtime=News_addtime,@show=show,@Thumbnail=Thumbnail,@width=width,@height=height,@titleColor=titleColor,@keywords=keywords from News where @News_ID=News_ID
return
end
go
Êý¾Ý¿âÖÐ news_content ÊÇtextÀàÐÍ News_IDΪintÖ÷¼ü×Ô¶¯Ôö³¤ µ±±£´æ´æ´¢¹ý³ÌµÄʱºòËûÒªÎÒÉùÃ÷news_contentºÍNew_id Çó×âÕâÊÇΪʲô
ûÓдíÎó°¡
²»»á°É ´íÎó170£ºµÚÈýÐÐ ¡°max¡±¸½½üÓï·¨´íÎó
±ØÐëÉùÃ÷±äÁ¿@News_ID
±ØÐëÉùÃ÷±äÁ¿@News_content
ÎÒµÄF5¿ì°´»µÁË ÇóÖú°¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
SQL code
{{----
Ïà¹ØÎÊ´ð£º
ÏÖÒ»·þÎñÆ÷£¬Ö§³ÖRAID5/RAID1+0µÈ£¬ÓÐ4¿éÒ»ÑùÐͺŵÄÓ²ÅÌ£¬°²×°ÁËRAID¿¨¡£
ÎÒËÑË÷ÁËÂÛ̳£¬ÓÐ˵Ҫ°ÑÊý¾Ý¿âÎļþ·Ö²¼ÔÚ²»Í¬´ÅÅÌ£¬µ«ÊÇ£¬×öraid5»òraid10ºó£¬4¿éÓ²Å̺ÃÏñ³ÉΪһÌåÁË£¬ÎÒ·Ö3¸ö·ÖÇø£¬Îļþ·Ö²¼ÔÚ²»Í¬· ......
SQL code:
begin tran
update EB with(rowlock) set Name='abc123' where Code=12 waitfor delay '00:00:13'
commit tran
ÎÒÓÃrowlockÏëËø¶¨Ò»ÐУ¬¿ÉÊÇËü°ÑÕû¸ö±í¶¼Ëø¶¨ÁË¡£²»¹ÜÎÒ¸üÐÂÄÄÒ»ÌõÊý¾Ý¶¼ ......
±ÈÈçsqlÓï¾äÊÇ£º
SQL code:
select top 300
CA01.A_id as '±ä¶¯´ÎÊý',
CA01.A0188 as 'ÈËÔ±id',
CA01.apname as 'ÉóÅúÕß',
CA01.CA0100 as 'È·ÈÏ״̬',
CA01.CA0101 as '±ä¶¯ÀàÐÍ',
CA01.CA0102 as 'Éê ......
sqlserver´æ´¢¹ý³Ì¸Äoracle
˻ᰡ¡£¡£¡£°ïæ¸Ä¸Ä··
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE tp_Fetch_List(
  ......
ÎÒÏë×öÒ»¸ö´¥·¢Æ÷£¬µ«Ð޸ıíTµÄ×Ö¶ÎC1ʱ£¬ÅжÏÈç¹ûÐ޸ĺóµÄֵΪ-1£¬Ôò¸üбíT¸ÃÐмǼµÄ×Ö¶ÎC2Ϊijֵ¡£
CreateTRIGGER [Tri_UpdateLastSaveDate] ON [dbo].[T]
for UPDATE
AS
BEGIN ......