Дед Анвирыч
Новичок
IDENTITY_INSERT
SELECT * INTO tmp FROM xxx..card WHERE serial<=4523
UPDATE tmp SET blocked=1
INSERT INTO yyy..card SELECT * FROM tmp
В ответ:
An explicit value for the identity column in table 'bill..card' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Что делать?
SELECT * INTO tmp FROM xxx..card WHERE serial<=4523
UPDATE tmp SET blocked=1
INSERT INTO yyy..card SELECT * FROM tmp
В ответ:
An explicit value for the identity column in table 'bill..card' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Что делать?