create table lei
(
lid int identity,
lname varchar(30)
)
create table biao
(
bid int primary key identity,
bname varchar(30),
age varchar(30),
lid int
)
--添加
create proc up_add
(
@bname varchar(30),
@age varchar(30),
@lid int
)
as
begin
insert into biao values(@bname,@age,@lid)
end
---修改--
create proc up_upt
(
@bid int,
@bname varchar(30),
@lid int
)
as
begin
update biao set [email?protected],[email?protected],[email?protected] where [email?protected]
end
----删除
create proc up_del
(
@bid int
)
as
delete from biao where [email?protected]
--查询---
create proc up_cha
@bid varchar(10),
@bname varchar(30),
@age varchar(30),
@lid varchar(10)
as
begin
declare @sqls nvarchar(max)
set @sqls = ‘select * from biao where 1=1‘;
if(@bid!=‘‘)
set @sqls +=‘ and ProductBrandId = ‘‘‘[email?protected]+‘‘‘‘;
if(@bname!=‘‘)
set @sqls += ‘ and ProductMenId = ‘‘‘[email?protected]+‘‘‘‘;
if(@age!=‘‘)
set @sqls += ‘ and ProductLuxuryId =‘‘‘[email?protected]+‘‘‘‘;
if(@lid!=‘‘)
set @sqls += ‘ and ProductLuxuryId =‘‘‘[email?protected]+‘‘‘‘;
exec(@sqls)endgoexec up_cha ‘‘,‘‘,‘‘