Click here to Skip to main content
12,690,140 members (30,626 online)
   

Database

 
AnswerRe: Resolved --> SQL Server + Procedure or function has too many arguments specified Pin
Hemant Thaker21-Feb-13 23:11
memberHemant Thaker21-Feb-13 23:11 
QuestionDual Primary Key? Pin
Richard.Berry10021-Feb-13 7:25
memberRichard.Berry10021-Feb-13 7:25 
AnswerRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 8:10
mvpEddy Vluggen21-Feb-13 8:10 
GeneralRe: Dual Primary Key? Pin
Richard.Berry10021-Feb-13 8:42
memberRichard.Berry10021-Feb-13 8:42 
Thanks Eddie, but you have totally lost me?

If I lok at the two lines:
ADD CONSTRAINT PK_MasterTable

Prevents any duplicates in MasterTable column

and

PRIMARY KEY CLUSTERED (WareHouseId, ProductId)

Stores the data physically sorted by WarehouseId then ProductID?

Or are there three Primary keys now?

If you look at the table in MSQuery, the Product is bold, so is this the primary key?
GeneralRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 9:32
mvpEddy Vluggen21-Feb-13 9:32 
GeneralRe: Dual Primary Key? Pin
Mycroft Holmes21-Feb-13 13:08
memberMycroft Holmes21-Feb-13 13:08 
GeneralRe: Dual Primary Key? Pin
PIEBALDconsult21-Feb-13 19:14
memberPIEBALDconsult21-Feb-13 19:14 
GeneralRe: Dual Primary Key? Pin
Eddy Vluggen21-Feb-13 23:42
mvpEddy Vluggen21-Feb-13 23:42 
Questionjdbc Pin
Durgesh1704r15-Feb-13 21:24
memberDurgesh1704r15-Feb-13 21:24 
AnswerRe: jdbc Pin
Richard MacCutchan15-Feb-13 23:31
mvpRichard MacCutchan15-Feb-13 23:31 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.170117.1 | Last Updated 16 Jan 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid