Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

How to write a stored procedure to insert values in to database automatically.  RSS feed

 
ashok movva
Greenhorn
Posts: 16
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I working on a attendance tracking project

I need to create rows for employees in attendance tracking table with all rows as null values, so that when a employee checkin at office  the values in the table will be updated.

Can any one help me in creating a stored procedure in creating the rows in the table automatically at particular time.

attendance tracking table is as follows


 
Dave Tolls
Ranch Hand
Posts: 2551
27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the point of creating a row with nothing (presumably apart from empid?) in it?
With a relational database the lack of a row would indicate that the employee had not checked in, and that would be enough.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!