--增加
insert into tb_brand(brandid,brandname,monthfee,basefee,smfee)
values('qqt','全球通',50,0.4,0.1)
go--添加用户品牌
begin
declare @brandid nvarchar(5),@brandname nvarchar(4)
declare @monthfee money,@basefee money,@smfee money
set @brandid = 'mzone'--'szx'--'qqt'
set @brandname = '动感地带'--'神州行'--'全球通'
set @monthfee = 15--1--50
set @basefee = 0.25--0.6--0.4
set @smfee = 0.05--0.15--0.1
if not exists(select brandid from tb_brand where brandid = @brandid or brandname = @brandname)
begin
insert into tb_brand(brandid,brandname,monthfee,basefee,smfee)
values(@brandid,@brandname,@monthfee,@basefee,@smfee)
print '数据添加成功!'
end
else
begin
print '数据存在重复内容,添加失败!'
end
end
goinsert 能往表里面添加信息, set 也能添加信息,请问2者有什么不同吗?
insert into tb_brand(brandid,brandname,monthfee,basefee,smfee)
values('qqt','全球通',50,0.4,0.1)
go--添加用户品牌
begin
declare @brandid nvarchar(5),@brandname nvarchar(4)
declare @monthfee money,@basefee money,@smfee money
set @brandid = 'mzone'--'szx'--'qqt'
set @brandname = '动感地带'--'神州行'--'全球通'
set @monthfee = 15--1--50
set @basefee = 0.25--0.6--0.4
set @smfee = 0.05--0.15--0.1
if not exists(select brandid from tb_brand where brandid = @brandid or brandname = @brandname)
begin
insert into tb_brand(brandid,brandname,monthfee,basefee,smfee)
values(@brandid,@brandname,@monthfee,@basefee,@smfee)
print '数据添加成功!'
end
else
begin
print '数据存在重复内容,添加失败!'
end
end
goinsert 能往表里面添加信息, set 也能添加信息,请问2者有什么不同吗?
declare @brandid nvarchar(5),@brandname nvarchar(4)
declare @monthfee money,@basefee money,@smfee money
set @brandid = 'mzone'--'szx'--'qqt' --变量赋值
set @brandname = '动感地带'--'神州行'--'全球通' --变量赋值
set @monthfee = 15--1--50 --变量赋值
set @basefee = 0.25--0.6--0.4 --变量赋值
set @smfee = 0.05--0.15--0.1 --变量赋值
if not exists(select brandid from tb_brand where brandid = @brandid or brandname = @brandname)
begin
insert into tb_brand(brandid,brandname,monthfee,basefee,smfee)
values(@brandid,@brandname,@monthfee,@basefee,@smfee) --将变量值添加进表记录!
print '数据添加成功!'
end
else
begin
print '数据存在重复内容,添加失败!'
end
values(@brandid,@brandname,@monthfee,@basefee,@smfee) 因为有这句!
凑合看看,能看懂多少算多少。