ALTER PROCEDURE cf_Number_Pic
@id int,
@number int
AS
declare @Sql nvarchar(4000)set @Sql='select top '+ Rtrim(convert(varchar,@number))
+' pic_url from tbl_car_pic where cartype_id='+convert(varchar,@id)
+' and is_neiwai=1 and isdelete=0 and isshow=0 order by pic_id desc'exec (@Sql)
@id int,
@number int
AS
declare @Sql nvarchar(4000)set @Sql='select top '+ Rtrim(convert(varchar,@number))
+' pic_url from tbl_car_pic where cartype_id='+convert(varchar,@id)
+' and is_neiwai=1 and isdelete=0 and isshow=0 order by pic_id desc'exec (@Sql)
@id int,
@number int
AS
declare @Sql nvarchar(4000)set @Sql='select top '+ Rtrim(convert(varchar,@number))
+' pic_url from tbl_car_pic where cartype_id='+convert(varchar,@id)
+' and is_neiwai=''1'' and isdelete=0 and isshow=0 order by pic_id desc'exec (@Sql)