I am running a stored procedure on confluence using Bob Swift's SQL pluing -
IF OBJECT_ID('dbo.test_Run_For_a_Day') IS NOT NULL
BEGIN
DROP TABLE dbo.test_Run_For_a_Day
END
GO
However I hit the following error each time. This command works fine with in the SQL management studio -
Error rendering macro 'sql' : java.sql.SQLException: Incorrect syntax near 'GO'
Answered here.
Hi Bob,
That link is dead. Is it possible to run stored procedures via the SQL plugin?
Kind regards
Jonas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.