摘要:
以下SQL以防以后还需用到,特此备份删除一条留言信息会级联删除回复信息,这时我们需要用到事务,如下SQL 1 ALTER PROCEDURE [dbo].[proc_tb_leaveword_delete] 2 ( 3 @leavewordID INT, 4 @record TINYINT OUTPUT 5 ) 6 AS 7 BEGIN 8 BEGIN TRY 9 BEGIN TRANSACTION10 DELETE FROM tb_leavewordID WHERE leavewordID=@leavewordID11... 阅读全文