-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â 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


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó