, 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