cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Server - Execute Snap

sdoscher
New Contributor III

A statement like this works fine in SQL Server. How can I get something like this to work in the SQL Server - Execute Snap? There has to be a syntax issue that I have. Any help is appreciated.

DECLARE @sql AS varchar(max) = ‘This is a Test’
PRINT @sql

13 REPLIES 13

Hi @sdoscher ,

In the documentation for SQL Server Execute, on the bottom you can see the versions:

image

BR,
Marjan

Hi @marjan.karafiloski That is the EXACT message I get. I spoke to the SL admin and he is willing to upgrade it. He had upgraded it…but then there was an issue and they rolled back. He said he will try again…TYSM!

sdoscher
New Contributor III

@marjan.karafiloski You literally are about 5 minutes ahead of me. 🙂 Working with the admin to see how we can upgrade. Thx!

sdoscher
New Contributor III

Upgrading to 4.27 worked. Thank you so much @marjan.karafiloski and @smudassir for for your help in solving this. It is GREATLY appreciated.