解决方案 »
- 查询所有数据库的表名称
- 数据库表怎么设计?考核打分表,有10个人对1000个人针对50个指标打分,一次考核就要向表中插入50万条记录,这样下去一年的考核数据启不把表冲爆?
- 关于触发器同时删除两个表的内容
- 函数的问题,初学者的
- 紧急求助,在线等待:如何关闭和打开自增列的自增功能
- 將表導出到Excel的問題
- J2EE程序中如何还原数据库(SQL2005)? 急啊!
- webservice中连接SQL数据库的错误大侠帮帮忙啦
- 请教SQL2005 查询字段描述 100分求教,分不够可以加
- 如何实现从18位编号的数据库中快速找到一个编号最大的记录
- 求SQL语句
- C# 里面continue 是跳出 进入下一个循环,那SQL里面哪个关键字是可以这样做的?
必须声明变量@News_ID
必须声明变量@News_content
--将nvarchar(max) 改为: varchar(max)
@News_subject nvarchar(1000) =null,
@News_content nvarchar(1000) =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_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 (ISNULL(@News_ID,'')<>'')
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;
ELSE
Select '对不起输入参数News_ID不能为空' '出错'
END--如果还不对的话:你先看你定义的变量跟原表中相应字段的类型是不是一样!
--或者把原表中相应字段的类型贴出来给我看看!
@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 (ISNULL(@News_ID,0)<>0)
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;
ELSE
Select '对不起输入参数News_ID不能为空' '出错'
END