Click here to Skip to main content
11,505,486 members (57,522 online)
   

Database

 
AnswerRe: Trigger for execute exe When inserted a receode to table Pin
Mycroft Holmes11-Jul-12 1:07
memberMycroft Holmes11-Jul-12 1:07 
AnswerRe: Trigger for execute exe When inserted a receode to table Pin
hiran12311-Jul-12 16:38
memberhiran12311-Jul-12 16:38 
GeneralRe: Trigger for execute exe When inserted a receode to table Pin
Mycroft Holmes11-Jul-12 17:57
memberMycroft Holmes11-Jul-12 17:57 
RantParameter Sniffing Pin
Mycroft Holmes10-Jul-12 15:11
memberMycroft Holmes10-Jul-12 15:11 
QuestionOracle SQL Developer Pin
vanikanc10-Jul-12 9:42
membervanikanc10-Jul-12 9:42 
AnswerRe: Oracle SQL Developer Pin
Michael Potter10-Jul-12 11:56
memberMichael Potter10-Jul-12 11:56 
AnswerRe: Oracle SQL Developer Pin
David Mujica11-Jul-12 2:39
memberDavid Mujica11-Jul-12 2:39 
GeneralRe: Oracle SQL Developer Pin
vanikanc11-Jul-12 3:01
membervanikanc11-Jul-12 3:01 
GeneralRe: Oracle SQL Developer Pin
David Mujica11-Jul-12 3:09
memberDavid Mujica11-Jul-12 3:09 
GeneralIntroduce integerity in the database Pin
sharp_k9-Jul-12 4:08
membersharp_k9-Jul-12 4:08 
GeneralRe: Introduce integerity in the database Pin
Wayne Gaylard9-Jul-12 4:24
mentorWayne Gaylard9-Jul-12 4:24 
GeneralRe: Introduce integerity in the database Pin
sharp_k9-Jul-12 4:47
membersharp_k9-Jul-12 4:47 
GeneralRe: Introduce integerity in the database Pin
jschell9-Jul-12 12:26
memberjschell9-Jul-12 12:26 
AnswerRe: Introduce integerity in the database Pin
Jörgen Andersson9-Jul-12 19:52
memberJörgen Andersson9-Jul-12 19:52 
Like others have said, you need to normalize your database.

When a customer is renewed you don't get a new customer and should therefore not get a new entry in the customer table, but rather a new entry in the subscription table or customer history table or whatever table makes most sense to your system.

As we don't know much about you database we can only give you generalized advice. Mine would be to read this[^] article.
It describes in an easy to understand way how to, and why, you normalize your database.
Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

GeneralRe: Introduce integerity in the database Pin
mark merrens9-Jul-12 5:17
membermark merrens9-Jul-12 5:17 
QuestionRe: Introduce integerity in the database Pin
Eddy Vluggen9-Jul-12 12:52
memberEddy Vluggen9-Jul-12 12:52 
AnswerRe: Introduce integerity in the database Pin
mark merrens10-Jul-12 12:05
membermark merrens10-Jul-12 12:05 
GeneralRe: Introduce integerity in the database Pin
PIEBALDconsult9-Jul-12 10:54
memberPIEBALDconsult9-Jul-12 10:54 
AnswerRe: Introduce integerity in the database Pin
Eddy Vluggen9-Jul-12 12:51
memberEddy Vluggen9-Jul-12 12:51 
Questionwhy (Object reference not set to an instance of an object)?! Pin
jrahma8-Jul-12 21:48
memberjrahma8-Jul-12 21:48 
AnswerRe: why (Object reference not set to an instance of an object)?! Pin
Simon_Whale9-Jul-12 4:24
memberSimon_Whale9-Jul-12 4:24 
AnswerRe: why (Object reference not set to an instance of an object)?! Pin
Luc Pattyn9-Jul-12 13:06
mvpLuc Pattyn9-Jul-12 13:06 
Questionupdate table structures from another server Pin
jrahma8-Jul-12 20:37
memberjrahma8-Jul-12 20:37 
AnswerRe: update table structures from another server Pin
Wayne Gaylard8-Jul-12 21:27
mentorWayne Gaylard8-Jul-12 21:27 
Questiontransfer mysql proceedures Pin
jrahma8-Jul-12 20:35
memberjrahma8-Jul-12 20:35 
QuestionError can not attach a database with the same name? Pin
Member 24584675-Jul-12 18:18
memberMember 24584675-Jul-12 18:18 
AnswerRe: Error can not attach a database with the same name? Pin
Midnight Ahri5-Jul-12 22:21
memberMidnight Ahri5-Jul-12 22:21 
GeneralRe: Error can not attach a database with the same name? Pin
Member 24584678-Jul-12 18:32
memberMember 24584678-Jul-12 18:32 
AnswerRe: Error can not attach a database with the same name? Pin
Mycroft Holmes5-Jul-12 23:37
memberMycroft Holmes5-Jul-12 23:37 
QuestionCopy stored procedures to another database why not? Pin
Member 24584675-Jul-12 17:34
memberMember 24584675-Jul-12 17:34 
AnswerRe: Copy stored procedures to another database why not? Pin
Mycroft Holmes5-Jul-12 17:52
memberMycroft Holmes5-Jul-12 17:52 
GeneralRe: Copy stored procedures to another database why not? Pin
Member 24584679-Jul-12 18:08
memberMember 24584679-Jul-12 18:08 
GeneralRe: Copy stored procedures to another database why not? Pin
Mycroft Holmes9-Jul-12 19:13
memberMycroft Holmes9-Jul-12 19:13 
Generalerror during update openquery [modified] Pin
mikcutu5-Jul-12 4:40
membermikcutu5-Jul-12 4:40 
GeneralRe: error during update openquery Pin
Eddy Vluggen8-Jul-12 0:21
memberEddy Vluggen8-Jul-12 0:21 
GeneralRe: error during update openquery Pin
mikcutu9-Jul-12 5:49
membermikcutu9-Jul-12 5:49 
Questionintegrate data of some DB into ome, how to? Pin
hs_rostami2-Jul-12 21:31
memberhs_rostami2-Jul-12 21:31 
AnswerRe: integrate data of some DB into ome, how to? Pin
Mycroft Holmes2-Jul-12 21:42
memberMycroft Holmes2-Jul-12 21:42 
AnswerRe: integrate data of some DB into ome, how to? Pin
Eddy Vluggen3-Jul-12 0:57
memberEddy Vluggen3-Jul-12 0:57 
GeneralRe: integrate data of some DB into ome, how to? Pin
hs_rostami3-Jul-12 21:47
memberhs_rostami3-Jul-12 21:47 
AnswerRe: integrate data of some DB into ome, how to? Pin
Eddy Vluggen4-Jul-12 1:01
memberEddy Vluggen4-Jul-12 1:01 
QuestionUsing float and like Pin
berba2-Jul-12 0:54
memberberba2-Jul-12 0:54 
AnswerRe: Using float and like Pin
Pete O'Hanlon2-Jul-12 2:52
protectorPete O'Hanlon2-Jul-12 2:52 
GeneralRe: Using float and like Pin
PIEBALDconsult2-Jul-12 6:59
memberPIEBALDconsult2-Jul-12 6:59 
AnswerRe: Using float and like Pin
PIEBALDconsult2-Jul-12 7:04
memberPIEBALDconsult2-Jul-12 7:04 
QuestionHow to run a job daily in Oracle and Generate excel file Pin
Rocky2328-Jun-12 22:40
memberRocky2328-Jun-12 22:40 
AnswerRe: How to run a job daily in Oracle and Generate excel file Pin
Eddy Vluggen29-Jun-12 3:15
memberEddy Vluggen29-Jun-12 3:15 
AnswerRe: How to run a job daily in Oracle and Generate excel file Pin
jschell29-Jun-12 8:55
memberjschell29-Jun-12 8:55 
Questionhow to get select parameter too in input parameter in stored procedure Pin
Dhyanga28-Jun-12 6:14
memberDhyanga28-Jun-12 6:14 
GeneralRe: how to get select parameter too in input parameter in stored procedure [modified] Pin
Luc Pattyn28-Jun-12 6:27
mvpLuc Pattyn28-Jun-12 6:27 

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

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


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 3 Jun 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid