写入简单的查询 [英] Write into simple query
本文介绍了写入简单的查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
hi
如何将此存储过程写入简单查询
更新 Con
SET Category1code = c1.Category1Name,Category2Code = c2.Category2Name
FROM 联系人Con
INNER JOIN Category1 As c1
ON Con.Category1Code = c1.Category1Code
内部 加入类别2 作为 c2
ON Con.Category2Code = c2.Category2Code;
提前预计
解决方案
您好...
创建 程序 dbo.UpdCategory
AS
BEGIN
BEGIN TRY
BEGIN TRANSACTION tnUpdCategory
UPDATE Con
SET Category1code = c1.Category1Name,Category2Code = c2.Category2Name
FROM 联系人Con
INNER JOIN Category1 As c1
ON Con.Category1Code = c1.Category1Code
内部 加入类别2 作为 c2
ON Con.Category2Code = c2.Category2Code;
COMMIT TRANSACTION tnUpdCategory
END TRY
BEGIN CATCH
IF @@ TRANCOUNT > 0 ROLLBACK TRANSACTION tnUpdCategory
PRINT ERROR_MESSAGE()
END CATCH
END 跨度>
hi
how can i write this stored procedure into simple query
UPDATE Con
SET Category1code =c1.Category1Name, Category2Code=c2.Category2Name
FROM Contacts Con
INNER JOIN Category1 As c1
ON Con.Category1Code = c1.Category1Code
Inner Join Category2 As c2
ON Con.Category2Code = c2.Category2Code;
thanx in advance
解决方案
Hi...
CREATE PROCEDURE dbo.UpdCategory AS BEGIN BEGIN TRY BEGIN TRANSACTION tnUpdCategory UPDATE Con SET Category1code =c1.Category1Name, Category2Code=c2.Category2Name FROM Contacts Con INNER JOIN Category1 As c1 ON Con.Category1Code = c1.Category1Code Inner Join Category2 As c2 ON Con.Category2Code = c2.Category2Code; COMMIT TRANSACTION tnUpdCategory END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION tnUpdCategory PRINT ERROR_MESSAGE() END CATCH END
这篇关于写入简单的查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文