CREATE PROCEDURE GetSendSMS
@str varchar(180) output
AS
BEGIN TRAN
declare @id bigint
declare @num varchar(12)
declare @contt varchar(144)
Select top 1 @id=[id],@num=[Number],@contt=[Content] From [Send] WITH(UPDLOCK, READPAST) order by id
if @id>0
begin
Insert into [sendlog] ([id],[Number],[Content])values(@id,@num,@contt)
delete from [send] Where id=@id
set @str=CAST(@id as varchar(11))+'{^}'+@num+'{^}'+@contt
end
else
begin
set @str=' no'
end
/*print @str
WAITFOR DELAY '00:00:20'*/
COMMIT TRAN
return @@RowCount
//WITH(UPDLOCK, READPAST) 锁定Select 记录 要在事务中才行