摘要: 以下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... 阅读全文
posted @ 2012-04-25 12:17 xu_happy_you 阅读(1169) 评论(1) 推荐(2) 编辑