1
I would like to pass a list of parameters to a precedent, how to do this process?
I did some research and I thought it is possible to create a TABLE TYPE and use it in the parameters of the past, but I could not use it, follow example.
CREATE TYPE TABLE_EXEC_PROCEDURE_MASSIVE_EXCHANGE_RELEASE_IMPORTED_FILE AS TABLE
(
ID_MASSIVE_EXCHANGE UNIQUEIDENTIFIER NOT NULL,
ID_IMPORTED_FILE_MASSIVE_EXCHANGE UNIQUEIDENTIFIER NOT NULL,
POSICAO INT NOT NULL,
USUARIO_EMAIL VARCHAR(250) NOT NULL,
USUARIO_NOME VARCHAR(250) NOT NULL,
JUSTIFICATIVA VARCHAR(MAX) NOT NULL
)
CREATE PROCEDURE SP_EXEC_MASSIVE_EXCHANGE_RELEASE_IMPORTED_FILE
@TABLE TABLE_EXEC_PROCEDURE_MASSIVE_EXCHANGE_RELEASE_IMPORTED_FILE READONLY AS
BEGIN
END
Someone would have some example?
Good morning, why don’t you send the dice in a string and in the database you throw the dice for a temporary... Where I work we do it that way and it works.
– Wellington Araujo