If exists (Select * From dbo.sysobjects Where id = object_id(N'[dbo].[sp_UpdateIsUser]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
Drop Procedure [dbo].[sp_UpdateIsUser]
Go
create Proc sp_UpdateIsUser
@ProgramId int,
@Uids varchar(200),
@DeleteUids varchar(200)
as
declare @PID varchar(20)
set @PID=Cast(@ProgramId as varchar);
Begin
Exec('
Update DDASCommandByTC set IsUser=0 where ProgramID =('+@PID+')and Uid not in ('+@Uids+')'
)
Exec(
'Update DDASCommandByTC set IsUser=1 where ProgramID=('+@PID+') and Uid in ('+@Uids+')'
)
if @DeleteUids <> null
Exec(
'Delete from DDASCommandByTC where ProgramID=('+@PID+') and Uid in ('+@DeleteUids+')'
)
End
Go