Click here to Skip to main content
15,907,328 members
Home / Discussions / Database
   

Database

 
GeneralRe: HOW TO FIND NO.OF ROWS UPDATED IN ONE TABLE TO STORE THAT VALUE IN OTHER TABLE Pin
Wendelius9-Nov-08 7:42
mentorWendelius9-Nov-08 7:42 
GeneralRe: HOW TO FIND NO.OF ROWS UPDATED IN ONE TABLE TO STORE THAT VALUE IN OTHER TABLE Pin
harsha_mec34510-Nov-08 21:00
harsha_mec34510-Nov-08 21:00 
GeneralRe: HOW TO FIND NO.OF ROWS UPDATED IN ONE TABLE TO STORE THAT VALUE IN OTHER TABLE Pin
Wendelius11-Nov-08 8:42
mentorWendelius11-Nov-08 8:42 
QuestionJoining to same table to display values next to each other Pin
Support1237-Nov-08 21:18
Support1237-Nov-08 21:18 
AnswerRe: Joining to same table to display values next to each other Pin
Wendelius8-Nov-08 0:54
mentorWendelius8-Nov-08 0:54 
GeneralRe: Joining to same table to display values next to each other Pin
Support12310-Nov-08 0:18
Support12310-Nov-08 0:18 
QuestionTable constraints problem Pin
JenovaProject7-Nov-08 15:11
JenovaProject7-Nov-08 15:11 
AnswerRe: Table constraints problem [modified] Pin
Wendelius7-Nov-08 20:26
mentorWendelius7-Nov-08 20:26 
JenovaProject wrote:
Is there a way to build a table so that no team can play two games on the same date


Add either unique constraint or unique index on those columns (single constraint with two fields). Just make sure that the time portion in the date is the same.

Something like:
ALTER TABLE XYZ ADD CONSTRAINT UK_SingleGame UNIQUE (date, home_id);

Then if you want you can create a similar constraint for date and away_id.

The need to optimize rises from a bad design.

My articles[^]

modified on Saturday, November 8, 2008 2:58 AM

QuestionJoin Pin
reogeo20087-Nov-08 6:11
reogeo20087-Nov-08 6:11 
AnswerRe: Join Pin
Jason Lepack (LeppyR64)7-Nov-08 6:34
Jason Lepack (LeppyR64)7-Nov-08 6:34 
AnswerRe: Join Pin
Blue_Boy7-Nov-08 7:08
Blue_Boy7-Nov-08 7:08 
QuestionArithmetic overflow error Pin
Vimalsoft(Pty) Ltd7-Nov-08 1:40
professionalVimalsoft(Pty) Ltd7-Nov-08 1:40 
AnswerRe: Arithmetic overflow error Pin
Ben Fair7-Nov-08 2:07
Ben Fair7-Nov-08 2:07 
GeneralRe: Arithmetic overflow error Pin
Vimalsoft(Pty) Ltd7-Nov-08 2:15
professionalVimalsoft(Pty) Ltd7-Nov-08 2:15 
Questionconnecting to sql 2005 express using vb2005 Pin
Michelle Shoniwa7-Nov-08 1:08
Michelle Shoniwa7-Nov-08 1:08 
AnswerRe: connecting to sql 2005 express using vb2005 Pin
Vimalsoft(Pty) Ltd7-Nov-08 1:35
professionalVimalsoft(Pty) Ltd7-Nov-08 1:35 
QuestionRestrict access to the database Pin
iamdking6-Nov-08 19:28
iamdking6-Nov-08 19:28 
AnswerRe: Restrict access to the database Pin
Ashfield6-Nov-08 20:54
Ashfield6-Nov-08 20:54 
AnswerRe: Restrict access to the database Pin
Wendelius7-Nov-08 7:43
mentorWendelius7-Nov-08 7:43 
QuestionExport of a CSV file loses second decimal place... Pin
new_phoenix6-Nov-08 4:38
new_phoenix6-Nov-08 4:38 
AnswerRe: Export of a CSV file loses second decimal place... Pin
riced6-Nov-08 5:36
riced6-Nov-08 5:36 
GeneralRe: Export of a CSV file loses second decimal place... Pin
new_phoenix6-Nov-08 7:14
new_phoenix6-Nov-08 7:14 
GeneralRe: Export of a CSV file loses second decimal place... Pin
Ashfield6-Nov-08 20:56
Ashfield6-Nov-08 20:56 
GeneralRe: Export of a CSV file loses second decimal place... Pin
new_phoenix7-Nov-08 4:16
new_phoenix7-Nov-08 4:16 
GeneralRe: Export of a CSV file loses second decimal place... Pin
Ashfield7-Nov-08 8:56
Ashfield7-Nov-08 8:56 

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.