êàê äîáàâèòü 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
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-