Friday, October 29, 2010
INSTEAD OF TRIGGER
create table test (id
intime int identity (1,1) , datetime,outtime datetime)
create trigger testtrigger on testinstead of update as begindeclare @outtime datetime
select @outtime = intime from insertedupdate test set outtime = @outtimeend
insert test (intime) values (GETDATE())
update test set intime = getdate()where id = 1
select * from test
Subscribe to:
Post Comments (Atom)
-
Most of the google tutorials on keras do not show how to display a confusion matrix for the solution. A confusion matrix can throw a clear l...
-
This error means you have created the DbContext but not configured/added it to the project using either DI in startup.cs or by using DbCon...
-
This happens when you dont define primary key for an entity type. Define a primary key either explicitly or implicitly.
No comments:
Post a Comment