如何从存储过程中声明的临时表更新表列 [英] how to update a table column from temporary table declared inside the stored procedure

问题描述

在存储过程中，我想从临时表@TempTable列COL-1更新Table-A的COL-1的值的价值。



请帮帮我。

谢谢，

Rajan。

Hi,
Inside a stored procedure, I would like to update value of "COL-1" of "Table-A" from a temporary table "@TempTable" column "COL-1" 's value.

Please help me out.
With Thanks,
Rajan.

推荐答案

您需要编写这样的更新查询：

You need to write your update query like this:

update LeaveSummary set OpCLSL = T.OpCLSL
FROM @TmpTble T
where ...

如果您的目的已经解决，请将此标记为答案。

谢谢

Please mark this as a answer if your purpose is solved.
Thanks

这篇关于如何从存储过程中声明的临时表更新表列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！