Click here to Skip to main content
15,917,964 members
Home / Discussions / Database
   

Database

 
AnswerRe: Problem in a query Pin
zahedonline21-Jul-08 1:43
zahedonline21-Jul-08 1:43 
Questionloading records problem Pin
harcaype19-Jul-08 16:50
harcaype19-Jul-08 16:50 
AnswerRe: loading records problem Pin
Ashfield20-Jul-08 8:20
Ashfield20-Jul-08 8:20 
QuestionRe: loading records problem Pin
harcaype22-Jul-08 3:28
harcaype22-Jul-08 3:28 
AnswerRe: loading records problem Pin
Ashfield22-Jul-08 8:44
Ashfield22-Jul-08 8:44 
QuestionOne to one Relationship problem Pin
snouto19-Jul-08 6:45
snouto19-Jul-08 6:45 
AnswerRe: One to one Relationship problem Pin
Wendelius19-Jul-08 8:39
mentorWendelius19-Jul-08 8:39 
AnswerRe: One to one Relationship problem Pin
zahedonline21-Jul-08 1:53
zahedonline21-Jul-08 1:53 
i suggest you the following things!!!

Create Primary Key for "ID" column in userinformation table and make it as IDENTITY,

Crate a new Primary Key column for accountinformation table something like
"accountinformationID" and make it as IDENTITY, Optional but good if you have one.

then Map Primary Key "ID" of userinformation table to "ID" column of accountinformation table, this process is called as Foreign Key creation

Now the basic you need to stick with is that

any insertion on table accountinformation made should have a matching "ID" value from userinformation table to the column "ID" of accountinformation table.

Hope this will help you out!!!! Blush | :O

ZAK

AnswerRe: One to one Relationship problem Pin
nelsonpaixao24-Jul-08 12:28
nelsonpaixao24-Jul-08 12:28 
QuestionNeed Arrange Query result into another table Header Pin
rrrriiizz19-Jul-08 1:45
rrrriiizz19-Jul-08 1:45 
AnswerRe: Need Arrange Query result into another table Header Pin
Ashfield20-Jul-08 8:06
Ashfield20-Jul-08 8:06 
GeneralRe: Need Arrange Query result into another table Header Pin
rrrriiizz20-Jul-08 22:54
rrrriiizz20-Jul-08 22:54 
AnswerRe: Need Arrange Query result into another table Header Pin
Mycroft Holmes20-Jul-08 14:47
professionalMycroft Holmes20-Jul-08 14:47 
GeneralRe: Need Arrange Query result into another table Header Pin
Paul Conrad20-Jul-08 14:55
professionalPaul Conrad20-Jul-08 14:55 
GeneralRe: Need Arrange Query result into another table Header Pin
Mycroft Holmes20-Jul-08 15:08
professionalMycroft Holmes20-Jul-08 15:08 
GeneralRe: Need Arrange Query result into another table Header Pin
rrrriiizz20-Jul-08 22:12
rrrriiizz20-Jul-08 22:12 
GeneralRe: Need Arrange Query result into another table Header Pin
Mycroft Holmes20-Jul-08 22:21
professionalMycroft Holmes20-Jul-08 22:21 
AnswerRe: Need Arrange Query result into another table Header Pin
zahedonline21-Jul-08 2:03
zahedonline21-Jul-08 2:03 
GeneralRe: Need Arrange Query result into another table Header Pin
rrrriiizz21-Jul-08 23:52
rrrriiizz21-Jul-08 23:52 
GeneralRe: Need Arrange Query result into another table Header Pin
zahedonline23-Jul-08 1:42
zahedonline23-Jul-08 1:42 
Questionsetup and deployment sql server 2005 database along with Setup file Pin
vishnukamath19-Jul-08 1:06
vishnukamath19-Jul-08 1:06 
AnswerRe: setup and deployment sql server 2005 database along with Setup file Pin
SimulationofSai19-Jul-08 4:30
SimulationofSai19-Jul-08 4:30 
AnswerRe: setup and deployment sql server 2005 database along with Setup file Pin
zahedonline21-Jul-08 2:07
zahedonline21-Jul-08 2:07 
QuestionHow i cast or convert Varchar column Data into Datetime Pin
Rameez Raja18-Jul-08 23:57
Rameez Raja18-Jul-08 23:57 
AnswerRe: How i cast or convert Varchar column Data into Datetime Pin
Blue_Boy19-Jul-08 0:55
Blue_Boy19-Jul-08 0:55 

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.