All Questions
6 questions
0
votes
1
answer
347
views
Select and Convert Date Of Birth from a table to check if their birthdays are today
I have a table called Genericattribute. It's as shown here.
I need to make a Trigger or a query that checks if today is the birthday of any of these employees.
I wrote a query that returns the Ids of ...
- 21
-1
votes
2
answers
60
views
SQL error: conversion failed when converting the varchar value '2020-11-26' to data type bit
I have this trigger - can you fix error please in this code?
INSERT INTO trSMSPoolHeader (SMSGatewayServiceCode, IsSent, SendDate, CreatedDate,
LastUpdatedDate, ...
- 25
0
votes
2
answers
6k
views
Using a Trigger to GETDATE()
I'm using a Trigger to update the Products table to the current date if the value for that column is null. I have everything yet, when I insert the new values into the table the DateAdded column for ...
- 25
0
votes
0
answers
108
views
Time taken by trigger for GetDate vs time taken for Milliseconds in SQL
I was doing the performance test of GetDate vs milliseconds in SQL. I run a trigger which inserts current time in field on update.
CREATE TRIGGER updateDate ON sm_activity
AFTER UPDATE
AS
BEGIN
...
- 438
1
vote
3
answers
2k
views
Trigger to update record when Value = GETDATE()
my experience with triggers is that it does something after an update,insert or delete. But is it possible to create a trigger to update a record automatically when its date is today? for example, I ...
0
votes
1
answer
319
views
SQL Server 2008 trigger throwing error when I use procedure GETDATE
I am trying to create a trigger in SQL Server 2008 which inserts a row into a 2nd database after an update in the 1st database.
However I keep getting an error..
(Procedure behaviour_alert, Line 11 ...
- 289