CREATE PROCEDURE [dbo].[sp_News _Headlines]
@Caltegoryid varchar ,
@Ncaltegoryid varchar ,
@RowsToReturn int
AS
set ROWCOUNT @RowsToReturn
select * from news
where Publisher = 1 and
(patIndex('%'+@Caltegoryid+'%',classid)>0 or
patIndex('%'+@Caltegoryid+'%',classid)>0) and
(patIndex('%'+@Ncaltegoryid+'%',nclassid)>0 or
patIndex('%'+@Ncaltegoryid+'%',nclassid)>0)
order by newsid desc
GO
@Caltegoryid varchar ,
@Ncaltegoryid varchar ,
@RowsToReturn int
AS
set ROWCOUNT @RowsToReturn
select * from news
where Publisher = 1 and
(patIndex('%'+@Caltegoryid+'%',classid)>0 or
patIndex('%'+@Caltegoryid+'%',classid)>0) and
(patIndex('%'+@Ncaltegoryid+'%',nclassid)>0 or
patIndex('%'+@Ncaltegoryid+'%',nclassid)>0)
order by newsid desc
GO
xeqtr1982(HaN) 你再给回复阿!
@Caltegoryid varchar(10),
@Ncaltegoryid varchar(10),
@RowsToReturn int
AS
set ROWCOUNT @RowsToReturn
select * from news
where Publisher = 1 and
(patIndex('%,'+@Caltegoryid+'%',classid)>0 or
patIndex('%'+@Caltegoryid+',%',classid)>0) and
(patIndex('%,'+@Ncaltegoryid+'%',nclassid)>0 or
patIndex('%'+@Ncaltegoryid+',%',nclassid)>0)
order by newsid desc
GO--这样?
如果我把+@Caltegoryid+替换成31,就可以的!?
CREATE PROCEDURE [dbo].[sp_News _Headlines]
@Caltegoryid varchar(10),
@Ncaltegoryid varchar(10),
@RowsToReturn int
AS
set ROWCOUNT @RowsToReturn
select * from news
where Publisher = 1 and
(patIndex('%,'+rtrim(@Caltegoryid)+'%',classid)>0 or
patIndex('%'+rtrim(@Caltegoryid)+',%',classid)>0) and
(patIndex('%,'+rtrim(@Ncaltegoryid)+'%',nclassid)>0 or
patIndex('%'+rtrim(@Ncaltegoryid)+',%',nclassid)>0)
order by newsid desc
GO
@Caltegoryid varchar(10),
@Ncaltegoryid varchar(10),
@RowsToReturn int
AS
set ROWCOUNT @RowsToReturn
select * from news
where Publisher = 1 and
(patIndex('%,'+rtrim(@Caltegoryid)+'%',classid)>0 or
patIndex('%'+rtrim(@Caltegoryid)+',%',classid)>0) or
(patIndex('%,'+rtrim(@Ncaltegoryid)+'%',nclassid)>0 or
patIndex('%'+rtrim(@Ncaltegoryid)+',%',nclassid)>0)
order by newsid desc
GO