写入简单的查询 [英] 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屋！