[Code: 137, SQL State: S1000] Must declare the scalar variable "@tableCount".
Is it not possible to execute T-SQL logic using variables in DbVis?
Hi,
Please check the following how to execute an SQL block in DbVisualizer:
http://confluence.dbvis.com/display/UG100/Executing+Complex+Statements
Regards
Roger
Aksturgeon
DECLARE @tableCount INT = 0;
SET @tableCount = (SELECT COUNT(*) FROM systables)
The error:
[Code: 137, SQL State: S1000] Must declare the scalar variable "@tableCount".
Is it not possible to execute T-SQL logic using variables in DbVis?