You’re offline. This is a read only version of the page.
630
Hello, I'm using a process of insert and I need to create a LineNbr, I know it has to negative but does it have to be consecutive? Is that a condition to the process or it's ok if I just insert a negative number?
*This post is locked for comments
I have the same question (0)
You did not indicate what table you are inserting a record into but it depends on whether the LineNbr field is part of a unique index into that table. If you open SQL Management studio and execute the following command
sp_help xxxxxx where xxxxxx is the table involved
you can scroll down to the index definitions for that table and see if LineNbr is part of a unique index. If the table is one of the standard SL tables then it is very likely that LineNbr must be unique or, at least, unique within the other elements of the index.
Share
Report
All responses (
Answers (
