|
kirank
Yak Posting Veteran
USA
50 Posts |
 Posted - 09/10/2011 : 13:26:14
|
hi here is my Sp
and i m getting this Error:
Msg 195, Level 15, State 10, Procedure sp_GetProductsPaging, Line 17
'varchar' is not a recognized built-in function name.
alter procedure [dbo].[sp_GetProductsPaging]
(
@PageNo int ,
@catid int ,
@subcatid int,
@mSortBy varchar(50)
)
as
begin
declare @PageSize as int
set @PageSize = 16
declare @tempTbl table(
catid as int, subcatid as int,prod_id as int,
productname as varchar(100) ,imagename as varchar(100),unitprice as int,listprice as int,onsale as varchar(100),
hotprod as varchar(100), prodDescription as varchar(100), caption as varchar(100), title as varchar(100) ,
prodfilename as varchar(100),rating as int,psubtype as varchar(100),sizelabel as varchar(100))
insert into @tempTbl
exec [sp_productdetails] @catid,@subcatid,@mSortBy
select * from (select ROW_NUMBER() over (
order by @mSortBy desc) as Row, * from @tempTbl)a
Where
Row > = ((@PageNo * @PageSize) +1 ) And Row <= ((@PageNo * @pageSize) + @PageSize)
end
on this line
productname as varchar(100) ,imagename as varchar(100),unitprice as int,listprice as int,onsale as varchar(100),
can u plz help me
http://webdevlopementhelp.blogspot.com |
|
error: 'varchar' is not a recognized built-in func
