看看创建存储过程的语句有什么问题？

[lily0000000]

CREATE PROCEDURE List_Report
(
@PageNumber int,
@RecordNumber int,
@Type varchar
)
AS
declare @tem1 varchar(10),@tem2 varchar(10),@tem3 varchar(50)
set @tem1=@RecordNumber
set @tem2=@RecordNumber*@PageNumber
set @tem3=@Type
exec("select top "+@tem1+" * from Briefing where
ID not in (select top "+@tem2+" ID from Briefing where typename="+@tem3+" order by UploadTime)
and typename="+@tem3+" order by UploadTime")
GO


我在asp.net中执行时总提示在‘order’附件语法有错误。应该是@tem3参数的传递问题。但这是个varchar型字段，参数也是这个类型，怎么会不对呢？

[CrazyFor]

CREATE PROCEDURE List_Report
(
@PageNumber int,
@RecordNumber int,
@Type varchar(50)
-------------------------^^^^^^
)
AS
declare @tem1 varchar(10),@tem2 varchar(10),@tem3 varchar(50)
set @tem1=@RecordNumber
set @tem2=@RecordNumber*@PageNumber
set @tem3=@Type
exec('select top '+@tem1+' * from Briefing where
ID not in (select top '+@tem2+' ID from Briefing where typename='''+@tem3+''' order by UploadTime)
and typename='''+@tem3+''' order by UploadTime')
GO

[pengdali]

CREATE PROCEDURE List_Report
(
@PageNumber int,
@RecordNumber int,
@Type varchar
)
AS
declare @tem1 varchar(10),@tem2 varchar(10),@tem3 varchar(50)
set @tem1=@RecordNumber
set @tem2=@RecordNumber*@PageNumber
set @tem3=@Type
exec('select top '+@tem1+' * from Briefing where
ID not in (select top '+@tem2+' ID from Briefing where typename='+@tem3+' order by UploadTime)
and typename='''+@tem3+''' order by UploadTime')
GO

[sdhdy]

CREATE PROCEDURE List_Report
(
@PageNumber int,
@RecordNumber int,
@Type varchar(50)
-------------------------^^^^^^
)
AS
declare @tem1 varchar(10),@tem2 varchar(10),@tem3 varchar(50)
set @tem1=@RecordNumber
set @tem2=@RecordNumber*@PageNumber
set @tem3=@Type
exec('select top '+@tem1+' * from Briefing where
ID not in (select top '+@tem2+' ID from Briefing
where typename='+''''+@tem3+''''+' order by UploadTime)
and typename='+''''+@tem3+''''+' order by UploadTime')
GO

[lily0000000]

to CrazyFor(蚂蚁) ( ):
你的语法看起来是对的，我也这样写过，运行时是不提示错误了，可是数据库中明明有匹配记录，就是一条记录也查询不出来。

to pengdali(大力 V2.0) ( ) ：
你的语法有问题，第二层括号中用的是单引号，但第一层中用"'，其实这两层应该是一样的吧

to sdhdy(大江东去...) ( )：
你写的语句在传递@tem3时用的是两层"（双引号）吗？这样好像不对噢

[lily0000000]

好了，解决了

[lily0000000]

可是，我还要问一下CrazyFor(蚂蚁) () ，为什么要用三个'呢？

[emayongxiang]

第一层用一个',
第二层用两个''
第三层用四个''''

第一层加第二层共三个'''

[lily0000000]

为什么要这么做呢？

[lily0000000]

结帖吧