Click here to Skip to main content
15,399,050 members
Home / Discussions / Database
   

Database

 
GeneralRe: Performance issue Pin
Colin Angus Mackay11-Oct-07 5:35
MemberColin Angus Mackay11-Oct-07 5:35 
GeneralRe: Performance issue Pin
Albu Marius11-Oct-07 6:31
MemberAlbu Marius11-Oct-07 6:31 
Questionhow to block ? Pin
ahmed eldeghedy11-Oct-07 2:58
professionalahmed eldeghedy11-Oct-07 2:58 
AnswerRe: how to block ? Pin
Colin Angus Mackay11-Oct-07 3:42
MemberColin Angus Mackay11-Oct-07 3:42 
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 
Hello Everybody
Table Name dbo.Books where I kept Books Information. At First You need to put All information on dbo.Books table. Now this book is not Active because I need to make a Copy of this book which will be stored at dbo.CopyBooks table.

dbo.Books table

ISBN BookName
1001 Sql Server 2000
1002 Sql Server 2005

Now I want to make Copy of those book

dbo.CopyBooks

ISBN Book_ID
1001 1001101
1001 1001102
1001 1001103
1002 1002101
1002 1002102
1002 1002103
1002 1002104

First four digit is ISBN number and last three digit indicate book copy number 101 is the First Copy, 102 is the Second Copy.

How will I do it?
Thanks


Sarfarj Ahmed

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 
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 

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.