All Questions
43 questions
1
vote
1
answer
218
views
Invalid object name 'inserted' inside trigger
I'm using EF Core and for payment table I define the following trigger that is valid, but when I am using my app, while inserting the new payment the context returns error on save:
Microsoft....
- 1,640
0
votes
2
answers
397
views
Is there a way to trigger a stored procedure at the end of all the insert/delete on an entity
My application is using Entity frame work and There is one table called t_details which holds multiple records. When the application gets saved, this entity gets deleted and added.
I also have a sql ...
- 77
0
votes
2
answers
86
views
SQL Server trigger on insert
When I try to insert a new record into the table I created the trigger on it does not create.
This is after I activated the trigger. When I deactivate it then repeated the insert, it goes through. ...
- 79
0
votes
0
answers
42
views
HTTP Function C# SQL ASYNC
I have an http trigger that calls a support function to perform a SQL update on some JSON. I made a mistake in the support function and used command.ExecuteNonQueryAsync() by accident. This code ran ...
- 21
1
vote
1
answer
575
views
How to trigger a function according to database after a given time?
I am developing a winforms/database software. It is a software that will be used by everyone in the office, using the same database. There is a column which holds "datetime" of a task. Also there is a ...
- 149
-1
votes
1
answer
222
views
Can I use SQL Triggers to track changes from C# Console App on Database?
I'm a newbie on using SQL Triggers, All I've done that I created an after-update trigger, that whenever I write a SQL update query it shows me the change, but I need to know If I have a console app ...
- 11
2
votes
3
answers
3k
views
Postgres C# Trigger Function
I am trying to call a function when new data is add to the database.
NpgsqlConnection connListenRun = new NpgsqlConnection("Server=main;Port=5432;Database=netdb;UserId=postgres;Password=password;");
...
- 642
0
votes
1
answer
376
views
Any other optimal way to update the parent table's columns when a child table is updated?
I have a few table structure look as below:
CREATE TABLE Person
(
PersonID INT PRIMARY KEY,
Name NVARCHAR(255),
LastUpdatedBy INT,
LastUpdatedDate DATETIME
);
CREATE TABLE Info
(
...
- 145
1
vote
0
answers
138
views
Fire trigger with cursor using Bulk Insert
I am using BulkInsert - works fine - and trigger - works fine - with cursor which is not working I think. Would you please look at my code and tell me what is my mistake?
Thank you very much.
...
- 894
0
votes
1
answer
249
views
MySQL - Table trigger prevents insert into table and returns no errors?
I am writing my first trigger an a MySQL DB. The idea of the trigger is to prevent anyone from inserting data with a measurement_date that falls into the rang of dates that already exists in the table....
- 1,550
0
votes
2
answers
413
views
Catch Inserted ID from Trigger
i'm new at SQL so, don't yell me. I have a problem with a trigger which is meant to catch last inserted data and update it.
create trigger ilgKodIsim on URTFIS instead of insert
as
SET NOCOUNT ON
...
- 9
0
votes
1
answer
59
views
improve performance in business application
I'm doing a business application in C# windows form.
About 10000 data entry per day.
current implementation for After Triggers:
1. Filter relevant data from the base table and insert to the ...
- 91
0
votes
1
answer
3k
views
Listen in application for insertion in database table
I have a SQL Server 2005 database which registers events from some device in one table. I need to catch these events, as they occur, in my C# application.
Events can occur at any time. I'm looking ...
- 583
0
votes
2
answers
5k
views
how to handle an exception in trigger?
I know this question may be possible duplicate of this question.But i didn't clear my confusion by this question. In SQL, we use a trigger for operation on database such as insert,update,delete ...
- 51
3
votes
2
answers
810
views
.Net SqlDataAdapter and triggers in SQL Server
I am using a trigger in SQL Server that works as required when executing a query in the query window in SQL Server Management Studio. The objective of the trigger is to take the latest value from one ...
- 65