[es] - Kako postaviti Identity

steffa
Damir Stefanović
Beograd

Član broj: 3996
Poruke: 33
*.vdial.verat.net.

Profil

Kako postaviti Identity_Insert na ON

^{13.07.2005. u 07:55 - pre 228 meseci}

Kako privremeno postaviti vrednost IDENTITY_INSERT na ON kako bih mogao da ubacim red u tabelu koja sadrži IDENTITY kolonu, a da pri ubacivanju zadam vrednost tog polja?

Pri pokušaju javlja grešku:

"Cannot insert explicit value for identity column in table 'Proizvod' when IDENTITY_INSERT is set to OFF."

Ili možda postoji drugi način za ovo?

Odgovor na temu

MilovanB
Sydney

Član broj: 61367
Poruke: 21
*.flexirent.com.

Profil

Re: Kako postaviti Identity_Insert na ON

^{14.07.2005. u 09:27 - pre 228 meseci}

upotrebi

SET IDENTITY_INSERT <ime_tvojr_tabele> ON

Evo ti kopija primera iz "SQL Server BOOKS ONLINE":

-----------------------------------------------------------------------------
Examples:

This example creates a table with an identity column and shows how the SET IDENTITY_INSERT setting can be used to fill a gap in the identity values caused by a DELETE statement.

-- Create products table.
CREATE TABLE products (id int IDENTITY PRIMARY KEY, product varchar(40))
GO
-- Inserting values into products table.
INSERT INTO products (product) VALUES ('screwdriver')
INSERT INTO products (product) VALUES ('hammer')
INSERT INTO products (product) VALUES ('saw')
INSERT INTO products (product) VALUES ('shovel')
GO

-- Create a gap in the identity values.
DELETE products
WHERE product = 'saw'
GO

SELECT *
FROM products
GO

-- Attempt to insert an explicit ID value of 3;
-- should return a warning.
INSERT INTO products (id, product) VALUES(3, 'garden shovel')
GO
-- SET IDENTITY_INSERT to ON.
SET IDENTITY_INSERT products ON
GO

-- Attempt to insert an explicit ID value of 3
INSERT INTO products (id, product) VALUES(3, 'garden shovel').
GO

SELECT *
FROM products
GO
-- Drop products table.
DROP TABLE products
GO
--------------------------------------------------------------------

Odgovor na temu