homepage Welcome to WebmasterWorld Guest from 54.166.122.86
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

    
Update The Status Using Trigger Programm
salman



 
Msg#: 4467569 posted 11:53 am on Jun 20, 2012 (gmt 0)

(code, sub_namesub_passMarks, sub_internalPassmarks)
(101, English, 32, 12)


(Roll_No, 101, 101_nt)
(24514, 35, 8)



(Roll_No,Backlock Status)


i have two tables first one is subject table and second one is student table..i want o write a trigger to generate "backlickStatus"
like

the student table field compare with the subject table code and check whether the student marks are greater than then update status as pass
other wise fail in "back-lock status"(it another table status)
PRIMARY KEYS-CODE,ROLL_NO

THANK YOU IN ADVANCE

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved