22,207
社区成员
发帖
与我相关
我的任务
分享
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE [dbo].[SP_DEPOT_SELECT]
@P_MobileId nvarchar(50)
AS
declare @sqlstr nvarchar(4000)
DECLARE @PhoneCount int
DECLARE @return_DateTime int
declare @DepotCount int
BEGIN
--将这条操作数据标示为当前用户
begin tran
set @sqlstr = ''
set @sqlstr = 'UPDATE [Depot] with(rowlock) SET [LockFlag] = @P_MobileId, LockDate = getdate() WHERE ID=(SELECT top(1)Id FROM depot where [LockFlag] is null or [LockFlag] = '''''
exec sp_executesql @sqlstr,N'@P_MobileId nvarchar(50)',@P_MobileId
commit
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
declare @P_MobileId nvarchar(50)
select @P_MobileId='[内容]'
declare @sqlstr nvarchar(4000)
DECLARE @PhoneCount int
DECLARE @return_DateTime int
declare @DepotCount int
set @sqlstr = ''
set @sqlstr = 'UPDATE [Depot] with(rowlock) SET [LockFlag] = @P_MobileId, LockDate = getdate() WHERE ID=(SELECT top(1)Id FROM depot where [LockFlag] is null or [LockFlag] = '''')'
print @sqlstr
ALTER PROCEDURE [dbo].[SP_DEPOT_SELECT]
@P_MobileId nvarchar(50)
AS
declare @sqlstr nvarchar(4000)
DECLARE @PhoneCount int
DECLARE @return_DateTime int
declare @DepotCount int
BEGIN
--将这条操作数据标示为当前用户
begin tran
set @sqlstr = ''
set @sqlstr = 'UPDATE [Depot] with(rowlock) SET [LockFlag] = @P_MobileId, LockDate = getdate() WHERE ID=(SELECT top(1)Id FROM depot where [LockFlag] is null or [LockFlag] = '''')'
exec sp_executesql @sqlstr,N'@P_MobileId nvarchar(50)',@P_MobileId
commit tran
END