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
{{----