Forum Discussion

derektd's avatar
derektd
Frequent Visitor
7 years ago

Executing Stored PRocedure with Direct Query Mode

Has anyone been able to get around this, yet.

 

I have tried: 

let SQLStoredProc = () => SQL.database("Server","Database",[Query="EXEC dbo.RPT_Report"])
in SQLStoredProc

 

Result - Details: "Microsoft SQL: Incorrect syntax near '='."

 

Tried:

let SQLStoredProc = () => SQL.database("Server","Database",[Query="EXEC [dbo].[RPT_FlashReport]"])
in SQLStoredProc

 

Result - Details: "Microsoft SQL: Incorrect syntax near '='. Unclosed quotation mark after the character string '])
in SQLStoredProc'."

 

Tried:

DECLARE @sqlCommand varchar(1000)

SET @sqlCommand = 'dbo.Testproc'
EXEC (@sqlCommand)

 

This one gets past the initial load and will bring me into query editor, but when I try to apply and close the result below occurs.

Result - Microsoft SQL: Incorrect syntax near the keyword 'DECLARE'. Incorrect syntax near ')'.

2 Replies