Click here to Skip to main content
15,559,459 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 21:25
JohnPayton21-May-12 21:25 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:34
jojoba201121-May-12 21:34 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 21:51
JohnPayton21-May-12 21:51 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 22:22
jojoba201121-May-12 22:22 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton22-May-12 13:52
JohnPayton22-May-12 13:52 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 18:58
jojoba201122-May-12 18:58 
Questiondata base system Pin
sajid ali laghari18-May-12 21:30
sajid ali laghari18-May-12 21:30 
AnswerRe: data base system Pin
Eddy Vluggen19-May-12 1:39
professionalEddy Vluggen19-May-12 1:39 
You draw an arrow from one entity to the other. Done.

Did you mean in code? What database-system? Here's one in SQL92;
SQL
CREATE TABLE Car
( 
  cId INTEGER,
  Description CHARACTER VARYING(50),
  PRIMARY KEY (cId)
)

CREATE TABLE CarPurchase
(
  pId INTEGER,
  boughtCar INTEGER,
  PRIMARY KEY (pId),
  FOREIGN KEY (boughtCar) REFERENCES Car
)

This syntax should work on most systems.
Bastard Programmer from Hell Suspicious | :suss:

QuestionHow to sort result if data fields contains both numeric and character value Pin
Rupesh Kumar Swami17-May-12 22:20
Rupesh Kumar Swami17-May-12 22:20 
AnswerRe: How to sort result if data fields contains both numeric and character value Pin
Eddy Vluggen19-May-12 1:32
professionalEddy Vluggen19-May-12 1:32 
QuestionExcel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult17-May-12 11:46
professionalPIEBALDconsult17-May-12 11:46 
AnswerRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson17-May-12 12:39
professionalJörgen Andersson17-May-12 12:39 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult17-May-12 15:20
professionalPIEBALDconsult17-May-12 15:20 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson17-May-12 21:36
professionalJörgen Andersson17-May-12 21:36 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult21-May-12 9:38
professionalPIEBALDconsult21-May-12 9:38 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson21-May-12 10:59
professionalJörgen Andersson21-May-12 10:59 
QuestionSerial number in SQL Pin
draghu17-May-12 1:17
draghu17-May-12 1:17 
AnswerRe: Serial number in SQL Pin
Pablo Aliskevicius17-May-12 3:48
Pablo Aliskevicius17-May-12 3:48 
AnswerRe: Serial number in SQL Pin
Andy_L_J17-May-12 21:51
Andy_L_J17-May-12 21:51 
GeneralRe: Serial number in SQL Pin
draghu17-May-12 23:11
draghu17-May-12 23:11 
QuestionSybase DB access in windows 7 Pin
VenkataRamana.Gali16-May-12 18:29
VenkataRamana.Gali16-May-12 18:29 
AnswerRe: Sybase DB access in windows 7 Pin
JohnsonLuis16-May-12 22:07
JohnsonLuis16-May-12 22:07 
QuestionOne to Many Relationships - Tabular Display Pin
eddieangel16-May-12 11:36
eddieangel16-May-12 11:36 
AnswerRe: One to Many Relationships - Tabular Display Pin
Jörgen Andersson16-May-12 12:26
professionalJörgen Andersson16-May-12 12:26 
GeneralRe: One to Many Relationships - Tabular Display Pin
eddieangel16-May-12 13:53
eddieangel16-May-12 13:53 

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.