I have table, where if data is inserted in two attempts, after that, noone can neither insert or update the data in the following table,e.g. First am...
Is there any way to solve this part?
While running the SELECT part, the output is not giving any error, the error coming through Trigger only.
Sir, 1 problem: CREATE TRIGGER UpdateDetails1 ON MyTable FOR INSERT, UPDATE AS BEGIN INSERT INTO DestinationTable ( Student, course, credit,...
Sir, Its working...thank you for the suggestion...THANKS A LOT [:)][:D]
Sir, Sorry for my wrong wordings. I had created the table as well as its trigger, but the correspondent event is not ocurring and am not getting the...
@Sandy: Sir, My aim is to insert/update data into DestinationTable, whenever data is being inserted/edited in MyTable, for this I created a Trigger,...
I have 2 tables: --CREATE TABLE create table MyTable ( Student varchar(10), course varchar(10), credit varchar(2) , gradeno int, remark varchar(10)...
Ok! SirI'll try to solve it by myself only and then show you!
Sir, atleast write me the insert/update/delete trigger for students part, rest I'll do by taking the reference of student part, hope you will help...
Sir, Am only 3 weeks old for MS SQL 2000, am still unknown to write this trigger/stored procedure. Please help me to write this trigger!
Actually, I want to automate the code and for that I need trigger so that update/insert in StudentMark become automated, whenever data is...
Hi All, I have a code snippet with insert T-SQL code, I want to make my insert code automatic through trigger, but I don't no, how should I do it,...
Separate names with a comma.
