Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Tag: trigger
Execution time of triggers fired when a procedure is executed in postgresql
Question : I have a stored procedure which may delete and/or insert tuples into a database table. This table has […]
Creating trigger from one database table to another database table postgresql
Question : I have two database say db1 and db2. And two tables user_auth_table in db1 and user_table in db2. […]
How to prevent database shrinking
Question : We have a 3° party application, with an application user who needs to be db_owner on the database […]
How to get output from trigger on linked server
Question : Fair warning, I know this isn’t the best way to do this, but I’m trying to extend some […]
Throw an error from the trigger?
Question : When trigger returns NULL, row is not inserted, but result of the operation is still reported as successful […]
What is the difference between tsvector_update_trigger and ts_vector generated column?
Question : Newbie to full text search, I have a feed_items table as follows feed_items (…title varchar, summary varchar, fullarticle […]
Trigger Performance – 1 or 2 Triggers?
Question : I have a question about triggers performance. CREATE TABLE [dbo].[_test]( [ID] [INT] IDENTITY(1,1) NOT NULL, [Date] [DATETIME] NULL, […]
Best practices for generating unique multi-column keys for weak entities?
Question : How should one generate non-unique, non-natural identifiers for weak entities? For example, if order_id is the primary key […]
Last time of trigger execution
Question : SQL SERVER 2014 – Is there a way to know last time of trigger execution ? Answer : […]