CREATE PROCEDURE [dbo].[PLAN_INFO_DELETE]
@ID INT
AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY
BEGIN TRAN
DELETE FROM [plan_info]
WHERE ID=@ID
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
END CATCH
END
SQL事务控制实例
最新推荐文章于 2024-01-25 21:13:36 发布