Help opennos

02/10/2017 14:57 Showk3#1
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 :)
02/10/2017 15:02 0Lucifer0#2
Just don't try to set something in a auto incremental column...
02/10/2017 22:07 Fizo55#3
Quote:
Originally Posted by Showk3 View Post
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;
:)
02/10/2017 23:37 0Lucifer0#4
Its an identity so its useless to try to put a value in it...