Click here to Skip to main content
15,881,173 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 20:25
JohnPayton21-May-12 20:25 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 20:34
jojoba201121-May-12 20:34 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton21-May-12 20:51
JohnPayton21-May-12 20:51 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201121-May-12 21:22
jojoba201121-May-12 21:22 
AnswerRe: How to get delete/Update row + SQL Pin
JohnPayton22-May-12 12:52
JohnPayton22-May-12 12:52 
QuestionRe: How to get delete/Update row + SQL Pin
jojoba201122-May-12 17:58
jojoba201122-May-12 17:58 
Questiondata base system Pin
sajid ali laghari18-May-12 20:30
sajid ali laghari18-May-12 20:30 
AnswerRe: data base system Pin
Eddy Vluggen19-May-12 0:39
professionalEddy Vluggen19-May-12 0: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 21:20
Rupesh Kumar Swami17-May-12 21:20 
AnswerRe: How to sort result if data fields contains both numeric and character value Pin
Eddy Vluggen19-May-12 0:32
professionalEddy Vluggen19-May-12 0:32 
QuestionExcel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult17-May-12 10:46
mvePIEBALDconsult17-May-12 10:46 
AnswerRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson17-May-12 11:39
professionalJörgen Andersson17-May-12 11:39 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult17-May-12 14:20
mvePIEBALDconsult17-May-12 14:20 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson17-May-12 20:36
professionalJörgen Andersson17-May-12 20:36 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
PIEBALDconsult21-May-12 8:38
mvePIEBALDconsult21-May-12 8:38 
GeneralRe: Excel, OleDb, ACE, and skipping header rows Pin
Jörgen Andersson21-May-12 9:59
professionalJörgen Andersson21-May-12 9:59 
QuestionSerial number in SQL Pin
draghu17-May-12 0:17
draghu17-May-12 0:17 
AnswerRe: Serial number in SQL Pin
Pablo Aliskevicius17-May-12 2:48
Pablo Aliskevicius17-May-12 2:48 
AnswerRe: Serial number in SQL Pin
Andy_L_J17-May-12 20:51
Andy_L_J17-May-12 20:51 
GeneralRe: Serial number in SQL Pin
draghu17-May-12 22:11
draghu17-May-12 22:11 
QuestionSybase DB access in windows 7 Pin
VenkataRamana.Gali16-May-12 17:29
VenkataRamana.Gali16-May-12 17:29 
AnswerRe: Sybase DB access in windows 7 Pin
JohnsonLuis16-May-12 21:07
JohnsonLuis16-May-12 21:07 
QuestionOne to Many Relationships - Tabular Display Pin
eddieangel16-May-12 10:36
eddieangel16-May-12 10:36 
AnswerRe: One to Many Relationships - Tabular Display Pin
Jörgen Andersson16-May-12 11:26
professionalJörgen Andersson16-May-12 11:26 
GeneralRe: One to Many Relationships - Tabular Display Pin
eddieangel16-May-12 12:53
eddieangel16-May-12 12: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.