if exists(select * from sysobjects where [id] = object_id(N'[dbo].[pro_product]')
and [xtype] in (N'P'))
drop procedure [dbo].[pro_product]
go
create procedure [dbo].[pro_product]
(@product_class varchar(50) =N''--分类ID
)
as
declare @sql varchar(256)
if(@product_class = N'')
begin
set @sql = 'select * from [dbo].[productview]'
end
else
begin
set @sql = 'select * from [dbo].[productview] where [dbo].[productview].[类别] = '+@product_class
end
exec(@sql)
go
将数据类型 varchar 转换为 float 时出错。
and [xtype] in (N'P'))
drop procedure [dbo].[pro_product]
go
create procedure [dbo].[pro_product]
(@product_class varchar(50) =N''--分类ID
)
as
declare @sql varchar(256)
if(@product_class = N'')
begin
set @sql = 'select * from [dbo].[productview]'
end
else
begin
set @sql = 'select * from [dbo].[productview] where [dbo].[productview].[类别] = '+@product_class
end
exec(@sql)
go
将数据类型 varchar 转换为 float 时出错。
and [xtype] in (N'P'))
drop procedure [dbo].[pro_product]
go
create procedure [dbo].[pro_product]
(@product_class varchar(50) =N''--分类ID
)
as
declare @sql varchar(256)
if(@product_class = N'')
begin
set @sql = 'select * from [dbo].[productview]'
end
else
begin
set @sql = 'select * from [dbo].[productview] where [dbo].[productview].[类别] = '+str(@product_class)
end
exec(@sql)
go
将数据类型 varchar 转换为 float 时出错。
if exists(select * from sysobjects where [id] = object_id(N'[dbo].[pro_product]')
and [xtype] in (N'P'))
drop procedure [dbo].[pro_product]
go
create procedure [dbo].[pro_product]
(@product_class varchar(50) =N''--分类ID
)
as
declare @sql varchar(256)
if(@product_class = N'')
begin
set @sql = 'select * from [dbo].[productview]'
end
else
begin
set @sql = 'select * from [dbo].[productview] where [dbo].[productview].[类别] = '+ltrim(@product_class) --转换为字符串
end
exec(@sql)
go
and [xtype] in (N'P'))
drop procedure [dbo].[pro_product]
go
create procedure [dbo].[pro_product]
(@product_class varchar(50) =N''--分类ID
)
as
declare @sql varchar(256)
if(@product_class = N'')
begin
set @sql = 'select * from [dbo].[productview]'
end
else
begin
set @sql = 'select * from [dbo].[productview]
where [dbo].[productview].[类别] = '''+@product_class+'''' --转换为字符串
end
exec(@sql)
go