Help opennos

[Showk3]

Hello guys , i have problem to create accounts IDENTITY INSERT ITS SET OFF
i write SET IDENTIYTY_INSERT ON and no func INDENTIYTY INSERT ON and no func IDENTITY_INSERT dbo.Account ON and not func help please

[0Lucifer0]

Just don't try to set something in a auto incremental column...

[Fizo55]

Originally Posted by Showk3

Hello guys , i have problem to create accounts IDENTITY INSERT ITS SET OFF
i write SET IDENTIYTY_INSERT ON and no func INDENTIYTY INSERT ON and no func IDENTITY_INSERT dbo.Account ON and not func help please

Not use a Navicat use the sql management and exécute the requete


SET IDENTITY_INSERT TableName ON;
INSERT INTO TableName (ColumnName1, ColumnName2)
VALUES (VALUESFORColumn1, VALUESFORColumn2)
SET IDENTITY_INSERT TableName OFF;

[0Lucifer0]

Its an identity so its useless to try to put a value in it...