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

¼±ÇóÖú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
{{----


Ïà¹ØÎÊ´ð£º

SQLSERVER 2000 ÔÚ RAID·þÎñÆ÷ÉÏ£¬¸ÃÈçºÎÅäÖã¿

ÏÖÒ»·þÎñÆ÷£¬Ö§³ÖRAID5/RAID1+0µÈ£¬ÓÐ4¿éÒ»ÑùÐͺŵÄÓ²ÅÌ£¬°²×°ÁËRAID¿¨¡£

ÎÒËÑË÷ÁËÂÛ̳£¬ÓÐ˵Ҫ°ÑÊý¾Ý¿âÎļþ·Ö²¼ÔÚ²»Í¬´ÅÅÌ£¬µ«ÊÇ£¬×öraid5»òraid10ºó£¬4¿éÓ²Å̺ÃÏñ³ÉΪһÌåÁË£¬ÎÒ·Ö3¸ö·ÖÇø£¬Îļþ·Ö²¼ÔÚ²»Í¬· ......

SqlServer ËøµÄÎÊÌâ

SQL code:
begin tran
update EB with(rowlock) set Name='abc123' where Code=12 waitfor delay '00:00:13'
commit tran


ÎÒÓÃrowlockÏëËø¶¨Ò»ÐУ¬¿ÉÊÇËü°ÑÕû¸ö±í¶¼Ëø¶¨ÁË¡£²»¹ÜÎÒ¸üÐÂÄÄÒ»ÌõÊý¾Ý¶¼ ......

200·ÖÇó´´½¨ÁÙʱ±í£¨sqlserver£©

±ÈÈç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

sqlserver´æ´¢¹ý³Ì¸Äoracle
Ë­»á°¡¡£¡£¡£°ïæ¸Ä¸Ä··


SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER    PROCEDURE tp_Fetch_List( 
  ......

sqlserver ´¥·¢Æ÷ÎÊÌâ

ÎÒÏë×öÒ»¸ö´¥·¢Æ÷£¬µ«Ð޸ıíTµÄ×Ö¶ÎC1ʱ£¬ÅжÏÈç¹ûÐ޸ĺóµÄֵΪ-1£¬Ôò¸üбíT¸ÃÐмǼµÄ×Ö¶ÎC2Ϊijֵ¡£

CreateTRIGGER [Tri_UpdateLastSaveDate] ON  [dbo].[T]
  for UPDATE
AS
BEGIN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ