How can i Update the status of field with a trigger thats ma example

create trigger MyTrigger on myTable after update as begin    set nocount on;    update talleres set status='active' where FirstDate=getdate() end go   create trigger MyTrigge2 on MyTable for update as begin    declare @d DATETIME=getdate();    set nocount on;    update talleres set status='Active' where FirstDate=format(@d,'MM/dd/YYYY') end go 

Does a fighter’s Action Surge trigger Extra Attack?


A player in my game will play a fighter with a greatsword. At 5th level he has Extra Attack and the option to use Action Surge. PHB p.72 states:

Action Surge. Starting at 2nd level, you can push yourself beyond your normal limits for a moment. On Your Turn, you can take one additional action on top of your regular action and a possible Bonus Action.

Once you use this feature, you must finish a short or Long Rest before you can use it again. Starting at 17th level, you can use it twice before a rest, but only once on the same turn.

Extra Attack. Beginning at 5th level, you can attack twice, instead of once, whenever you take the Attack action on Your Turn.

The number of attacks increases to three when you reach 11th level in this class and to four when you reach 20th level in this class.


The questions and answers that I find on here deal with multi-classing or Two Weapon fighting specifically, which don’t really give a clear yes or no on my question.

The way I read these two features is that when a fighter takes an Attack action, he gets the Extra Attack. After using Action Surge he gets the opportunity to take another Attack action, and with that another Extra Attack. This results in four attacks with the greatsword in one turn, which sounds amazing but also rather powerful. Is this correct, or am I missing something?

Trigger MYSQL con multiples UPDATES

Amablemente solicito de su colaboración con el siguiente trigger de MySql.

UPDATE ventas SET fecha = now()  WHERE estado='Vigente'; UPDATE ventas SET update = "system"  WHERE estado='Cancelado'; 

El trigger funciona, pero quisiera saber como puedo hacer algo asi:

UPDATE ventas SET fecha = now()  WHERE estado='Vigente',                SET update = "system"  WHERE estado='Cancelado'; 

Lo anterior es dado que en la tabla de ventas tengo un tigger Before Update, y quiero hacer una sola actualización a la linea, y no dos como está pasando.

Muchas gracias

Pb TRIGGER Before Insert SQL

I’m trying to check an insertion in a column before it’s added to my table. If the insertion is null I want to assign a value based on another column of the same table.

My source table is ‘article’ it contains these columns: id, titre, resume, contenu. If ‘resume’ is null I need to pick the first 150 characters in column ‘contenu’ to set the column ‘resume’.

DELIMITER | CREATE TRIGGER before_insert_article BEFORE INSERT ON article FOR EACH ROW  BEGIN     IF NEW.resume IS NULL         THEN              SET NEW.resume = (SELECT LEFT (NEW.contenu, 150) FROM article WHERE = ; END IF ; END |  DELIMITER ; 

So… of course, it doesn’t work. I think I understand why but like I’m very new in SQL I just can’t find out how can I solve my problem. Any tips?

Banishment with other spells that trigger when entering a space

I had a game where I had a Paladin and two Warlocks. Paladin and Warlock A casted two spells (Moonbeam, and Noxious Cloud) that both trigger when a creature enters or starts their turn in the area of effect.

The creature in question was already in the overlapping area for both, and made its saving throws. On the turn of Warlock B, he casted Banishment, which teleported the creature to a benign dimension, but immediately brought it back, hoping to trigger the reentering of the space of the two damage spells.

At the time of play, I allowed it and made the creature make new saves, which it failed, and died.

My question is: is this the proper way to handle the banishment and return of the creature? If a creature is banished and brought back, does it count as reentering the space it was in? Or should it have been treated as already being in that area, and make the saves when the creature starts its next turn in that area?

Can Neewer 3-in-1 remotes be used to trigger both flash and shutter at the same time?

I have 3 in 1 Neewer remotes, one transmitter and 4 receivers. Can I use the receivers to fire the flash and activate the shutter with the transmitter at the same time? I notice there is a flash and shutter or camera slide on the sides, does this mean all I can do is one or the other? I have a Neewer 670 flash unit and an El cheapo flash that came in the camera kit. I would like to use remote shutter and remote flash when pressing the remote transmitter button, not sure if that will happen. I am afraid to try.