Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ´´½¨·¢²¼

ÎÒÔÚѧϰʹÓÃSQL Server Compact Edition´´½¨Òƶ¯Ó¦ÓóÌÐò£¬¿ÉÊÇÔÚÊý¾Ý¿â´´½¨·¢²¼µÚÒ»²½Ê±Ìáʾ´íÎóÈçÏ£º
There are no publications to which you subscribe,either because this server  has no publicati ......

sqlserver°²×°²»ÉÏ

ÎҵĵçÄÔ֨װÁËϵͳ¡£ÖØ×°ºóɾ³ýÁËһЩÒÔǰ°²×°µÄsqlserver Îļþ¡£ÖØ×°ÏµÍ³ºóÏë°²×°sqlserver¡£ÓÃÐéÄâ¹âÇý°²×°¾µÏñÎļþµçÄÔȴû·´Ó¦¡£Çë¸ßÊÖÖ¸µãһϡ£ºÜ¼±¡£
û·´Ó¦£¿

ʲô´íÒ²²»±¨»¹ÊÇÔõôµÄ£¿

ÄѵÀ¾µÏ ......

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

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

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

SqlServer´æ´¢½á¹¹ÓëÒ»¸öË÷ÒýÎÊÌâ

SQL code:

CREATE TABLE TUser
(
FName CHAR(8000),
FAge INT,
FSex bit
)
INSERT INTO TUser
SELECT 'ÕÅÈý',18,1
UNION ALL
SELECT 'ÀîËÄ',20,1
UNION ALL
SELECT 'ÍõÎå',32,1
UNION ALL
SE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ