Question: DECLARE @RunStoredProcSQL VARCHAR ( 1 0 0 0 ) ; SET @RunStoredProcSQL = 'EXEC ctw . [ dbo ] . [ nca _ opentimeupdates ]

DECLARE @RunStoredProcSQL VARCHAR(1000);
SET @RunStoredProcSQL = 'EXEC ctw.[dbo].[nca_opentimeupdates]55569,''F4C74'',20240430,''CA'',''OTA'',20240430,10,10';
EXEC (@RunStoredProcSQL) AT [CTWPSQLQE01];
Print 'Procedure Executed';
The above SQL Server Query I am using in SSMS
but the stored proc is created in PSQL
Below is attached SS for Stored proc.
So i want to run this PSQL stored proc from SQL server SSMS server
Linked server is created for CTWPSQLQE01 and working fine.
DECLARE @RunStoredProcSQL VARCHAR ( 1 0 0 0 ) ;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!