从其他数据库执行简短程序 [英] Execute Short Procedure from other Database

问题描述

美好的一天

我想从另一个数据库执行一个简短的过程.

我要执行的简短过程在CallAgain数据库中.简短的过程名称是:TSH_TerminalConfigUpdate.

我已经编写了以下代码，但收到错误消息.

Good day

I want to execute a short procedure from a another database.

The short procedure that I want to execute is in the CallAgain database. The short procedures name is: TSH_TerminalConfigUpdate.

I have written the following code, but I get an error message.

CREATE PROCEDURE SELTermConfigUpdate
AS
BEGIN
SET NOCOUNT ON;
USE [CallAgain]
Exec dbo.TSH_TerminalConfigUpdate

END
GO

-消息154，级别15，状态1，过程SELTermConfigUpdate，第14行
在过程，函数或触发器中不允许使用USE数据库语句.

如何从另一个数据库执行存储过程?

-Msg 154, Level 15, State 1, Procedure SELTermConfigUpdate, Line 14
a USE database statement is not allowed in a procedure, function or trigger.

How do I execute a stored Procedure from another database?

推荐答案

尝试使用此方法

Try with this

CREATE PROCEDURE SELTermConfigUpdate
AS
BEGIN
SET NOCOUNT ON;
USE [CallAgain]
Exec [DATABASE NAME]..TSH_TerminalConfigUpdate

END
GO

* [数据库名称] =数据库名称将是sp TSH_TerminalConfigUpdate的写入位置.

* [DATABASE NAME] = database name will be where the sp TSH_TerminalConfigUpdate is written.

ALTER PROCEDURE [dbo].[SELTermConfigUpdate]
AS
BEGIN
SET NOCOUNT ON;
Exec CallAgain.dbo.TSH_TerminalConfigUpdate 

--CallAgain是另一个数据库名称

-TSH_TerminalConfigUpdate是短程序名称

--CallAgain is the other database name

-- TSH_TerminalConfigUpdate is the short procedures name

这篇关于从其他数据库执行简短程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！