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'
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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.