Software Deployment Question
K1000: SQL variables
12/18/2014 3400 views
I was trying to do exactly the same as bostonbound in http://www.itninja.com/question/mysql-user-defined-variables, using variables in a kace´s report. But it gives errors (just in Kace, not in MySQL).
so im just looking for confirmation, is it still not possible to use variables in Kace??
SET @DataInicial = '2014-12-10';
SET @DataFinal = '2014-12-13';
select U.FULL_NAME AS ATENDENTE, HD_QUEUE.NAME AS FILA, @DataInicial as DataInicial,@DataFinal as DataFinal
Be the first to answer this question