check particular cell value and not insert again new value

Question

Hi In my database I have 3 columns ie. IdNameSubject(Marks).I inserted records as 1Sai 20. When I am trying to insert new marks to the Sai it won't accept new marks to the Sai. That means I want to restrict to re-enter the marks for particular record and it allows only one time to enter marks.. How to write code for this.. ??

Rahul Prajapat · Answer

Hello @sureshma use the trigger for restrict upadte  try following code create trigger NotUpdate on instead of update as begin Print 'You can not re-enter the marks' end

Hariharasudhan Chandramurthy · Answer

To make it clear you want to update the marks if the record already exists?