-

   rss_sql_ru_access_programming

 - e-mail

 

 -

 LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


Primary Key (PK) Query

, 29 2014 . 14:26 +



SELECT Atacand_Brand_Total.ClientID, Atacand_Brand_Total.ClientsName, Atacand_Brand_Total.ClientsAddress, Atacand_Brand_Total.[Macro Region], Atacand_Brand_Total.[SLSM Brick], Atacand_Brand_Total.Subject, Atacand_Brand_Total.CompanyType, Atacand_Brand_Total.CompanyChannel, Atacand_Brand_Total.CustomerGroup, Atacand_Brand_Total.StatementID, Atacand_Brand_Total.Brand, Atacand_Brand_Total.Product, Atacand_Brand_Total.SumOfSumOfAmount, Atacand_Brand_Total.SumOfSumOfValue_CP, [ClientID] & [Brand] AS Code
FROM Atacand_Brand_Total;

(SKU_ID) PK ( 1, 2, 3, )
:

ALTER TABLE Atacand_Brand_Total
ADD CONSTRAINT PK_Number PRIMARY KEY (SKU_ID)



, ?

http://www.sql.ru/forum/1097525/kak-dobavit-primary-key-pk-v-novuu-tablicu-s-pomoshhu-query


: [1] []
 

:
: 

: ( )

:

  URL