易截截图软件、单文件、免安装、纯绿色、仅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 2005导出数据到office 2007 Excel

代码:
insert into openrowset('microsoft.ace.oledb.12.0','excel 12.0;hdr=yes;database=d:\a.xslx','select * from [sheet1$]') select * from table
注意:导出的数据和表头要一 ......

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( 
  ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号