Click here to Skip to main content
15,391,277 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Server CE 3.5 AutoIncrement Pin
Wendelius15-Oct-08 4:24
mveWendelius15-Oct-08 4:24 
QuestionORA-01722 Error Pin
Rane14-Oct-08 2:04
MemberRane14-Oct-08 2:04 
AnswerRe: ORA-01722 Error Pin
Wendelius14-Oct-08 5:22
mveWendelius14-Oct-08 5:22 
Questionhow to execute this oracle function ??? Pin
dilipmca0413-Oct-08 23:37
Memberdilipmca0413-Oct-08 23:37 
AnswerRe: how to execute this oracle function ??? Pin
Wendelius14-Oct-08 5:05
mveWendelius14-Oct-08 5:05 
QuestionDatabase design Questions? Pin
sepel13-Oct-08 23:23
Membersepel13-Oct-08 23:23 
AnswerRe: Database design Questions? Pin
bcozican14-Oct-08 2:09
Memberbcozican14-Oct-08 2:09 
GeneralRe: Database design Questions? Pin
Mark Churchill14-Oct-08 2:42
MemberMark Churchill14-Oct-08 2:42 
Use inheritance in your database, so you can add different subclasses of Advert later.

From our docs:
In this example, a ServiceProduct and a StockProduct table are defined. Both primary key columns
are also declared as foreign keys referencing the Product.Id column. These relationships guarantee
that for every ServiceProduct or StockProduct record there will be a corresponding Product record
with the same Id. Effectively these two tables inherit from the product table...



QuestionQuery Help Pin
Jaffer Mumtaz13-Oct-08 20:20
MemberJaffer Mumtaz13-Oct-08 20:20 
AnswerRe: Query Help Pin
bcozican14-Oct-08 2:18
Memberbcozican14-Oct-08 2:18 
GeneralRe: Query Help Pin
Jaffer Mumtaz14-Oct-08 18:41
MemberJaffer Mumtaz14-Oct-08 18:41 
QuestionMultiple columns in LIKE Pin
N a v a n e e t h13-Oct-08 15:58
MemberN a v a n e e t h13-Oct-08 15:58 
AnswerRe: Multiple columns in LIKE Pin
Mycroft Holmes13-Oct-08 17:42
professionalMycroft Holmes13-Oct-08 17:42 
GeneralRe: Multiple columns in LIKE Pin
N a v a n e e t h13-Oct-08 19:23
MemberN a v a n e e t h13-Oct-08 19:23 
GeneralRe: Multiple columns in LIKE Pin
Andrew Rissing14-Oct-08 6:43
MemberAndrew Rissing14-Oct-08 6:43 
QuestionLoading column having $ sign to SQL Server... Pin
notes4we13-Oct-08 7:56
Membernotes4we13-Oct-08 7:56 
AnswerRe: Loading column having $ sign to SQL Server... Pin
Wendelius13-Oct-08 9:22
mveWendelius13-Oct-08 9:22 
QuestionArchiving a record Pin
Bolivarian13-Oct-08 7:07
MemberBolivarian13-Oct-08 7:07 
AnswerRe: Archiving a record Pin
Wendelius13-Oct-08 9:25
mveWendelius13-Oct-08 9:25 
GeneralRe: Archiving a record Pin
Bolivarian14-Oct-08 0:12
MemberBolivarian14-Oct-08 0:12 
GeneralRe: Archiving a record Pin
Wendelius14-Oct-08 4:54
mveWendelius14-Oct-08 4:54 
QuestionLEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer13-Oct-08 7:05
Memberpolishprogrammer13-Oct-08 7:05 
AnswerRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
Wendelius13-Oct-08 7:36
mveWendelius13-Oct-08 7:36 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
polishprogrammer13-Oct-08 11:01
Memberpolishprogrammer13-Oct-08 11:01 
GeneralRe: LEFT JOIN - GET ONLY ONE RESULT FROM RIGHT TABLE Pin
Wendelius13-Oct-08 18:12
mveWendelius13-Oct-08 18:12 

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.