Click here to Skip to main content
15,395,473 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to block ? Pin
Paul Conrad12-Oct-07 12:04
professionalPaul Conrad12-Oct-07 12:04 
AnswerRe: how to block ? Pin
Colin Angus Mackay11-Oct-07 7:00
MemberColin Angus Mackay11-Oct-07 7:00 
GeneralRe: how to block ? Pin
Paul Conrad12-Oct-07 12:05
professionalPaul Conrad12-Oct-07 12:05 
QuestionCopy Information Pin
Sarfaraj Ahmed11-Oct-07 0:58
MemberSarfaraj Ahmed11-Oct-07 0:58 
AnswerRe: Copy Information Pin
pmarfleet11-Oct-07 2:00
Memberpmarfleet11-Oct-07 2:00 
GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 3:19
MemberSarfaraj Ahmed11-Oct-07 3:19 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 8:59
Memberpmarfleet11-Oct-07 8:59 
GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 3:55
MemberSarfaraj Ahmed11-Oct-07 3:55 
about dbo.fine

AutoID MemberID ReturnDate ReturnOn Fine

1 S10001 23/10/2007 25/10/2007 1.00
2 S10002 21/10/2007 25/10/2007 2.00
3 S10003 21/10/2007 2.00

I wolud like create this table like this,

on dbo.fine table will automatically check ReturnDate column from dbo.borrowBook table add fine on Fine.Fine table. It will will be check CurrentDate and ReturnDate.

How will I create this Table? Any Instruction.......


Sarfarj Ahmed

GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 9:00
Memberpmarfleet11-Oct-07 9:00 
GeneralRe: Copy Information Pin
Sarfaraj Ahmed11-Oct-07 15:09
MemberSarfaraj Ahmed11-Oct-07 15:09 
GeneralRe: Copy Information Pin
pmarfleet11-Oct-07 21:39
Memberpmarfleet11-Oct-07 21:39 
Questionupdate database(urgently) Pin
Milind Panchal10-Oct-07 22:51
MemberMilind Panchal10-Oct-07 22:51 
AnswerRe: update database(urgently) Pin
N a v a n e e t h10-Oct-07 23:09
MemberN a v a n e e t h10-Oct-07 23:09 
AnswerRe: update database(urgently) Pin
Rob Philpott11-Oct-07 4:46
MemberRob Philpott11-Oct-07 4:46 
Questionis the order of parameters addition to a command for update command realy required? Pin
nicolus10-Oct-07 20:23
Membernicolus10-Oct-07 20:23 
AnswerRe: is the order of parameters addition to a command for update command realy required? Pin
John Gathogo11-Oct-07 4:54
MemberJohn Gathogo11-Oct-07 4:54 
QuestionComplex Query Pin
Aavesh Agarwal10-Oct-07 20:21
MemberAavesh Agarwal10-Oct-07 20:21 
AnswerRe: Complex Query Pin
_Damian S_10-Oct-07 20:50
professional_Damian S_10-Oct-07 20:50 
GeneralRe: Complex Query Pin
Aavesh Agarwal10-Oct-07 21:03
MemberAavesh Agarwal10-Oct-07 21:03 
GeneralRe: Complex Query Pin
Rob Philpott11-Oct-07 4:40
MemberRob Philpott11-Oct-07 4:40 
QuestionHow to use Form Authentication in SSRS Pin
krishbasu10-Oct-07 19:47
Memberkrishbasu10-Oct-07 19:47 
Questionwhile poop in stored procedure Pin
Sonia Gupta10-Oct-07 18:47
MemberSonia Gupta10-Oct-07 18:47 
AnswerRe: while poop in stored procedure Pin
joemonvarghese10-Oct-07 19:15
Memberjoemonvarghese10-Oct-07 19:15 
GeneralRe: while poop in stored procedure Pin
Sonia Gupta10-Oct-07 19:17
MemberSonia Gupta10-Oct-07 19:17 
GeneralRe: while poop in stored procedure Pin
Christian Graus10-Oct-07 19:31
mveChristian Graus10-Oct-07 19:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.