You can use the SP_EXECUTESQL with a parameter OUTPUT to get the desired result:DECLARE @tjt INT; DECLARE @query NVARCHAR(MAX); SET @query = '(select @tjt = sum(duracao) from tabela where fabrica = ' + @fabrica + ' and turno IN (' + @turnos + '))'; EXEC SP_EXECUTESQL @query, N'@tjt INT OUT', @tjt OUT; SELECT @tjt;

From what I understand, you want to remove the brackets from the column name. To remove the brackets from the column name is only to insert quotes before the first bracket and after the last bracket.As in the example below:EXEC sp_rename '"[minhaColunaNova]"', 'minhaColunaNova'; Reference: https://stackoverflow.com/a/21169214/10508872

You will need to assemble an SQL dynamically using campo as variable:CREATE PROCEDURE nome_procedure(campo VARCHAR(15)) BEGIN SET @temp1 = CONCAT('SELECT id as id, ', campo, ' as value FROM tabela etc etc etc'); PREPARE stmt1 FROM @temp1; EXECUTE stmt1; DEALLOCATE PREPARE stmt1; END $$

You must check the NULL with IS rather than = (The reason you can check in the answer of the question https://pt.stackoverflow.com/a/87518/59479 . After that you should use the function https://msdn.microsoft.com/pt-br/library/ms186819(v=sql.120).aspx to return the current date -1 day:CREATE PROCEDURE Dbo.AtualizaTMP_Venda( @IdContrato INT = NULL ) AS BEGIN IF @IdContrato IS NULL BEGIN SELECT DATEADD(DAY, -1, GETDATE()) AS data; RETURN; END; -- Continua a execução normal END; GO https://msdn.microsoft.com/pt-br/library/ms186819(v=sql.120).aspx Returns a specified date with the specified numeric range (signed whole) added to the part of the specified date.

After a lot of tests and mistakes I managed to solve. I don't know if it's the best solution, but I did.No machine.config there is a definition of <oracle.manageddataaccess.client>:<configSections> <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> </configSections> So I added that statement in web.config and worked perfectly. I believe that web.config do not be joining the settings machine.config. If you have similar problems, try that which might work.

Icaro, have you tried to do that? the only detail here is that the months that had no sale will not list.SELECT CASE MONTH(dt_contabil) WHEN 1 THEN 'Jan' WHEN 2 THEN 'Fev' WHEN 3 THEN 'Mar' WHEN 4 THEN 'Abr' WHEN 5 THEN 'Mai' WHEN 6 THEN 'Jun' WHEN 7 THEN 'Jul' WHEN 8 THEN 'Ago' WHEN 9 THEN 'Set' WHEN 10 THEN 'Out' WHEN 11 THEN 'Nov' WHEN 12 THEN 'Dez' END AS Periodo, SUM(vl_subtotal_itens) as Valor FROM venda_geral WHERE YEAR(dt_contabil) = 2018 GROUP BY MONTH(dt_contabil) UNION ALL SELECT CONVERT(VARCHAR(MAX),YEAR(dt_contabil)) AS Periodo, SUM(vl_subtotal_itens) as Valor FROM venda_geral WHERE YEAR(dt_contabil) = 2018 GROUP BY YEAR(dt_contabil)

You could create a variable, assign the @@IDENTITY value to the variable and use it in the inserts. So: ALTER PROCEDURE adicionarNovoLivro( @nome_livro varchar(255), @nome_autor varchar(255), @ano_livro int, @nome_editora varchar(100), @id_livro int, @preco_livro float ) AS BEGIN INSERT INTO tbl_LivrosA VALUES(@nome_livro, @nome_autor, @ano_livro, @nome_editora, @preco_livro) SELECT @id_livro = @@IDENTITY INSERT INTO tbl_LivrosB VALUES(@id_livro, @nome_livro, @nome_autor, @ano_livro, @nome_editora, @preco_livro) INSERT INTO tbl_LivrosC VALUES(@id_livro, @nome_livro, @nome_autor, @ano_livro, @nome_editora, @preco_livro) END

I don't understand why you need two updates, can do with only one, using https://codigofonte.com.br/codigos/estrutura-de-condicao-case-em-queries-sql-no-mysql :DELIMITER $ CREATE PROCEDURE modificaSalario2() BEGIN UPDATE Funcionario SET Salario = Salario * (CASE WHEN Salario < 1000 THEN 1.10 ELSE 0.85 END); END $ DELIMITER ;

In postgres to use conditional code flow control, the IF ... THEN ... ELSIF ... THEN ... ELSE ... END IF, as documentation. https://www.postgresql.org/docs/current/plpgsql-control-structures.html#PLPGSQL-CONDITIONALS CREATE OR REPLACE FUNCTION atualizasaldo() RETURNS trigger AS $$ BEGIN if (TG_OP = 'DELETE') then update conta set saldo = (select sum(valor) from operacao where id_operacao = OLD.id_operacao) WHERE id_conta = OLD.id_conta; elsif (TG_OP = 'UPDATE') then update conta set saldo = (select sum(valor) from operacao where id_operacao = OLD.id_operacao) WHERE id_conta = OLD.id_conta; elsif (TG_OP = 'INSERT') then update conta set saldo = (select sum(valor) from operacao where id_operacao = NEW.id_operacao) WHERE id_conta = NEW.id_conta; end if; END $$ LANGUAGE PLPGSQL;

The main mistake would be the BEGIN and END who was using us IF.You can see the documentation https://mariadb.com/kb/en/library/if/ .As it was: DELIMITER $$ CREATE DEFINER = `root`@`localhost` PROCEDURE `Teste`(IN `@valor` INT, IN `@post` INT,IN `@user` INT) BEGIN IF NOT EXISTS(SELECT * FROM curtida WHERE user = `@user` AND post = `@post`) THEN INSERT INTO curtida (tipo, post, user) VALUES (`@valor`, `@post`, `@user`); ELSEIF ((SELECT tipo FROM curtida WHERE user = `@user` AND post = `@post`) = `@valor`) THEN DELETE FROM curtida WHERE user = `@user` AND post = `@post`; ELSE UPDATE curtida SET tipo = `@valor` WHERE user = `@user` AND post = `@post`; END IF; END $$ DELIMITER ;

Doesn't make sense two inserts at the same time, since this command is directed to a table; but you can have two in the same Pro:DELIMITER // CREATE PROCEDURE proccomdoisinserts(IN valorX INT, IN valorY INT) BEGIN INSRT INTO tabelaX(colunaX) VALUES (valorX); INSRT INTO tabelaX(colunaX) VALUES (valorY); END; // DELIMITER ;

Basically that:INSERT INTO tabela SET coluna = IF( @variavel IN (1,2,3), 1, 0 ); O IN returns true if the variable is in the listO IF returns the second value if the first expression is true, or returns the third.See working on http://sqlfiddle.com/#!9/1093dd/1 .Notes:In T-SQL from 2012, there is the function IIF, which works the same way as the IF MySQL/MariaDBFor other DBs have the CASE, can see more in detail in this post: https://pt.stackoverflow.com/questions/268905/70

After entering the user, use SELECT LAST_INSERT_ID(); to get id created user, store the id in a variable and then insert the supplier.

Every time we're riding one string and within that string it is necessary to have another string, we have some exits:As in SQL so ' as " start and finish one string, we can intercallate these characters to form a string inside the other:set @comando = 'select count(*) as qtdeCaminhoes'; set @comando = concat(@comando, ' from tb_vbv where classe = "'); set @comando = concat(@comando, classe); set @comando = concat(@comando, '"'); The result of this would be:select count(*) as qtdeCaminhoes from tb_vbv where class = "content_de_class"But if you really want to get around string with ', you can use the previous inverted method("'"), or use \ which is an escape character, the ' or " after it will not be considered as closure of a string:set @comando = 'select count(*) as qtdeCaminhoes'; set @comando = concat(@comando, ' from tb_vbv where classe = \''); set @comando = concat(@comando, classe); set @comando = concat(@comando, '\''); Another information on the function CONCAT is that it accepts several parameters to concatenate at once, its code could be summarized for this for example:set @comando = 'select count(*) as qtdeCaminhoes'; set @comando = concat(@comando, ' from tb_vbv where classe = '); set @comando = concat(@comando, '\'', classe, '\'');

Use the commands PREPARE and EXECUTE:PREPARE myquery FROM comando; EXECUTE myquery; You can do more research links https://tableless.com.br/prepared-statements-no-mysql/ .delimiter $$ create procedure eixos_caminhao (in numeroEixos int) begin set @comando := 'select classe, velocidade, date(data) as data, pesoEixo1, pesoEixo2'; if (numeroEixos > 2) set @comando:= concat(@comando, ', pesoEixo3'); if (numeroEixos > 3) set @comando:= concat(@comando, ', pesoEixo4'); if (numeroEixos > 4) set @comando:= concat(@comando, ', pesoEixo5'); if (numeroEixos > 5) set @comando:= concat(@comando, ', pesoEixo6'); if (numeroEixos > 6) set @comando:= concat(@comando, ', pesoEixo7'); if (numeroEixos > 7) set @comando:= concat(@comando, ', pesoEixo8'); if (numeroEixos > 8) set @comando:= concat(@comando, ', pesoEixo9'); set @comando:= concat(@comando, ' from tb_vbv'); PREPARE myquery FROM @comando; EXECUTE myquery; end; delimiter;

The answer this in the error message, has insufficient parameters in the call, its function has 4 parameters and you are calling it with 3, missing pass the vOPR.

If the stored procedure returns a cursor to be used with visual data controls, add a data source component to the data module and set your DataSet property as the data set of the type of stored procedure. Connect components with data recognition to the data source using its DataSource and DataField properties.You should use "Active" property of the "StoredProcedure"ZStoredProc1.Prepare; ZStoredProc1.Active:= True; http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Using_Stored_Procedure-type_Datasets

It has, knowing well how each bank works:)This is undoubtedly the best way, to have one or two professionals who understand well, especially if procedure use very specific features such as hints. But, to help, it has this site that converts most basic syntax of various databases online, not only oracle and sql-server: http://www.sqlines.com/online I suggest putting the query there that will help a lot, leaving functional, there you focus on the very specific things. To help with this, you have this great material comparing the two databases in English: https://docs.oracle.com/cd/E10405_01/appdev.120/e10379/ss_oracle_compared.htm

You can even set up a generic procedure that can insert data in any table, but this is not common to be done.CREATE PROCEDURE [InserirUsuario] ( @tableName varchar(45) , @column1 varchar(45) , @dado1 varchar(45) , @column2 varchar(45) , @dado2 varchar(45) ) AS BEGIN DECLARE @SqlCommand NVARCHAR(MAX) SET @SqlCommand = N'INSERT INTO ' + @tableName + '(' + @column1 + ',' + @column2 + ') VALUES (''' + @dado1 + ''',''' + @dado2 + ''')' EXEC SP_EXECUTESQL @SqlCommand END In this case you would mount a string with your command and then run it, of course it would lack the question of field format, but as I quoted it, it is not something cool to create a generic procedure this way, mainly because each table can have a different amount of fields.You could replace the fact that you create multiple parameter fields to use only one XML field that could have N column and value fields.

After having opened this questioning I was immersed a couple of days in the MYSQL forums in English looking for similar problems and making the famous: "tentative and error". I found people who had the same problem, but for other reasons.It turns out that, in my procedure, vw "vw_magic_levels" owned a union that was making the query have a massive volume of data, making mysql finished. I changed view to remove the union and the process, running via procedure worked. The only mystery I couldn't solve was because it worked outside the procedure and in the procedure no. Anyway, I appreciate those who lost a little time reading the topic.NOTE: I have no way to publish the links here because I searched for most of the time away from my PC and did not save, sorry.