error with reftab_hive

[thoubi96]

Msg 8101, Level 16, State 1, Line 61
An explicit value for the identity column in table 'Tab_RefHive' can only be specified when a column list is used and IDENTITY_INSERT is ON.



what should i do i dont rly understand actually what is wrong

[Schickl]

The ID column is an identity column.
This means that the value is generated by the server
Just don't include that column when inserting, or if you really need to specify the ID do what the error suggests you: set IDENTITY_INSERT to ON
Look there for more info:

[IceAmStiel]

Aight people.. take advantage of the identity columns, I know it might be annoying sometimes to insert data in tables with lots of columns but you can make it much more simple..

Declare	@String nvarchar(1024);
SELECT	@String = ISNULL(@String, N'') + name + N', ' FROM sys.columns WHERE object_id = OBJECT_ID(N'Tab_RefHive') AND is_identity = 0;

SELECT	N'INSERT INTO Tab_RefHive (' + LEFT(@String, LEN(@String) - 1) + N') VALUES (..)';

Output:

[thoubi96]

Originally Posted by IceAmStiel

Aight people.. take advantage of the identity columns, I know it might be annoying sometimes to insert data in tables with lots of columns but you can make it much more simple..

Declare	@String nvarchar(1024);
SELECT	@String = ISNULL(@String, N'') + name + N', ' FROM sys.columns WHERE object_id = OBJECT_ID(N'Tab_RefHive') AND is_identity = 0;

SELECT	N'INSERT INTO Tab_RefHive (' + LEFT(@String, LEN(@String) - 1) + N') VALUES (..)';

Output:

so that query makes it work?

`do i run this for shard or for that table?

[IceAmStiel]

Assuming you want to insert data into Tab_RefHive, simply exclude the identity column from the column list in the insert statement.
My query prepares the string for insertions into a table that has an identity column (replace the ".." with your intput parameters).