How to define multiple variables at once within a trigger in SQLServer

Question

How to define multiple variables at once within a trigger in SQLServer

Navigation

#1 by (1 votes)

0

Hello, I'm creating a TRIGGER where I should do a series of treatments after an UPDATE in a table in SQLServer. In this TRIGGER, I need to set some variables so I can work with them in the rest of the script, like this:

CREATE TABLE foo (
    id INT NOT NULL IDENTITY(1,1) PRIMARY KEY,
    nome NVARCHAR(100) NOT NULL,
    telefone NVARCHAR(30) NOT NULL DEFAULT '',
    email NVARCHAR(100) NOT NULL DEFAULT ''
);

GO

CREATE TRIGGER [TR_foo_onUpdate] ON foo AFTER UPDATE AS
BEGIN

    SET NOCOUNT ON;

    DECLARE @id BIT = (SELECT id FROM inserted),
            @nome NVARCHAR(100) = (SELECT nome FROM inserted),
            @telefone NVARCHAR(30) = (SELECT telefone FROM inserted),
            @email NVARCHAR(100) = (SELECT email FROM inserted);

    /* continuação do script aqui... */

END

My question is this, is there any way I can do the declare without having to do 4 SELECT 's? The question is more for optimization because it can certainly be used in many other scripts ...

sql-server

asked by anonymous 30.05.2018 / 18:47

1 answer

Get or return a variable for the angle event with scroll javascript

score 1 · Accepted Answer

DECLARE @id BIT,
        @nome NVARCHAR(100),
        @telefone NVARCHAR(30),
        @email NVARCHAR(100);


SELECT @id = id,
       @nome = nome,
       @telefone = telefone,
       @email = email
  FROM inserted