----修改----
ALTER PROCEDURE [dbo].[sp_DJAreas_update]
@Id varchar(50),
@Name varchar(255),
@AreaType int,
@PQType int,
@Summary varchar(500),
@LastUserId varchar(32),
@Status int,
@Flags int
WITH EXEC AS CALLER
AS
--判断该记录是否存在
IF EXISTS(SELECT Id FROM tblDJAreas AS area WHERE Id<>@Id AND Name=@Name AND IsDelete=0)
RETURN 10015;
IF @Status=16
BEGIN
IF EXISTS(SELECT Id FROM tblDJUserInfo WHERE AreaId=@Id AND IsDelete=0)
RETURN 10010;
IF EXISTS(SELECT OrgId FROM tblDJAreaInOrgs WITH(NOLOCK) WHERE AreaId=@Id AND IsDelete=0)
RETURN 10011;
IF EXISTS(SELECT Id FROM tblDJAreas WHERE Name=LTRIM(RTRIM(@Name)) AND Id<>@Id AND IsDelete=0)
RETURN 10015;
END
--修改
UPDATE
tblDJAreas
SET
[Name] = isnull(@Name, [Name])
,AreaType = isnull(@AreaType, AreaType)
,PQType = isnull(@PQType, PQType)
,Summary = isnull(@Summary, Summary)
,LastModify = GETDATE()
,LastUserId = isnull(@LastUserId, LastUserId)
,Status = isnull(@Status, Status)
,Flags = isnull(@Flags, Flags)
WHERE
Id = @Id
SQL Server 存储过程update
最新推荐文章于 2023-06-07 16:34:21 发布