Fordraiders
asked on
do i need a terminator(or something else) between dynamic sql statements
working with Oracle Linked server in SSMS 2008R2
do i need a terminator(or something else) between OPENQUERY/dynamic sql statements
I have this line of code
Thanks
fordraiders
do i need a terminator(or something else) between OPENQUERY/dynamic sql statements
I have this line of code
TRUNCATE TABLE [dbo].[XREF_HEADER_DETAIL_ORACLE_EXTRACT_2019_STAGING]
begin try
DECLARE @StartDate AS VARCHAR(10) = '07-JAN-19';
DECLARE @EndDate AS VARCHAR(10) = convert(varchar, getdate(), 101);
DECLARE @Statement NVARCHAR(MAX) = N'
SELECT *
FROM OPENQUERY(
XREF_PROD,
''SELECT
etcx...... code
EXECUTE sys.sp_executesql @Statement;
end try
BEGIN CATCH
select
ERROR_NUMBER() AS ErrorNumber,
ERROR_STATE() AS ErrorState,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_PROCEDURE() AS ErrorProcedure,
ERROR_LINE() AS ErrorLine,
ERROR_MESSAGE() AS ErrorMessage;
END CATCH
--- do i need additional code here between statements/dynamic sql statements ?
--- next dynamic sql statement
TRUNCATE TABLE [dbo].[ORACLE_CUST]
SELECT *
FROM OPENQUERY(
XREF_PROD,
''SELECT reportsTor,
code etcccc...
Thanks
fordraiders
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
The second block does not contain dynamic SQL, btw.