You could put your code inside a stored procedure and connect to that.
Please create a store procedure and try to connect to that.
I tried it after creating a stored procedure. But while executing the stored procedure, I am again facing the same problem with 'EXEC' keyword.
Can you plz help me on this.?
Again facing the error as
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'EXECUTE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.
Please help me on this.
You will need to provide the definition of the stored procedure.
Thanks Tom.! I have created a user defined function and called it from tableau and it worked.!