交换数据代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】交换数据
作者:明蔚 / 发布于2016/3/21/ 1058
create procedure Exchange
@id1 int,
@id2 int 
as

declare @tempUrl varchar(max)
declare @tempImageUrl varchar(max)
declare @tempTitle varchar(max)
declare @tempGroup_purchase_price varchar(50)
declare @tempDiscount varchar(50)
declare @tempOriginal_Price varchar(50)
declare @tempSold varchar(50)
declare @tempGroup_purchase_info_name varchar(50)
declare @tempCity varchar(50)
declare @tempRegion varchar(50)
declare @tempStartTime varchar(max)
declare @tempEndTime varchar(max)
declare @tempPurchase_type varchar(50)

--交换 a和b

--t=a

set @tempUrl =(select url from TB_Group_Purchase_Info where id=@id1)
set @tempImageUrl =(select imageUrl from TB_Group_Purchase_Info where id=@id1)
set @tempTitle=(select title from TB_Group_Purchase_Info where id=@id1)
set @tempGroup_purchase_price=(select group_purchase_price from TB_Group_Purchase_Info where id=@id1)
set @tempDiscount=(select discount from TB_Group_Purchase_Info where id=@id1)
set @tempOriginal_Price=(select original_Price from TB_Group_Purchase_Info where id=@id1)
set @tempSold=(select sold from TB_Group_Purchase_Info where id=@id1)
set @tempGroup_purchase_info_name=(select group_purchase_info_name from TB_Group_Purchase_Info where id=@id1)
set @tempCity=(select city from TB_Group_Purchase_Info where id=@id1)
set @tempRegion=(select region from TB_Group_Purchase_Info where id=@id1)
set @tempStartTime=(select startTime from TB_Group_Purchase_Info where id=@id1)
set @tempEndTime=(select endTime from TB_Group_Purchase_Info where id=@id1)
set @tempPurchase_type=(select purchase_type from TB_Group_Purchase_Info where id=@id1)

 --a=b

update dbo.TB_Group_Purchase_Info set url=(select url from TB_Group_Purchase_Info where id=@id2),
imageUrl=(select imageUrl from TB_Group_Purchase_Info where id=@id2),
title=(select title from TB_Group_Purchase_Info where id=@id2),
group_purchase_price=(select group_purchase_price from TB_Group_Purchase_Info where id=@id2),
discount=(select discount from TB_Group_Purchase_Info where id=@id2),
sold=(select sold from TB_Group_Purchase_Info where id=@id2),
group_purchase_info_name=(select group_purchase_info_name from TB_Group_Purchase_Info where id=@id2),
city=(select city from TB_Group_Purchase_Info where id=@id2),
region=(select region from TB_Group_Purchase_Info where id=@id2),
startTime=(select startTime from TB_Group_Purchase_Info where id=@id2),
endTime=(select endTime from TB_Group_Purchase_Info where id=@id2),
purchase_type=(select purchase_type from TB_Group_Purchase_Info where id=@id2)
where id=@id1


 --b=t
update dbo.TB_Group_Purchase_Info set url=@tempUrl,
imageUrl=@tempImageUrl,
title=@tempTitle,
group_purchase_price=@tempGroup_purchase_price,
discount=@tempDiscount,
original_price=@tempOriginal_Price,
sold=@tempSold,
group_purchase_info_name=@tempGroup_purchase_info_name,
city=@tempCity,
region=@tempRegion,
startTime=@tempStartTime,
endTime=@tempEndTime,
purchase_type=@tempPurchase_type
where id=@id2

 

 


print 'url:'+@tempUrl
print 'imageurl:'+@tempImageUrl
print 'group_purchase_price:'+@tempGroup_purchase_price
print 'discount:'+@tempDiscount
print 'original_Price:'+@tempOriginal_Price
print 'sold:'+@tempSold
print 'group_purchase_info_name:'+@tempGroup_purchase_info_name
print 'city:'+@tempCity
print 'region:'+@tempRegion
print 'startTime:'+@tempStartTime
print 'endTime:'+@tempEndTime
print 'purchase_type:'+@tempPurchase_type
试试其它关键字
　交换数据　
同语言下
可能有用的
明蔚贡献的其它代码(9)