Viewing 15 posts - 4,096 through 4,110 (of 22,211 total)
Query the sys.columns system view. It has a column, is_identity. If a table is not using the identity function, you can see it there.
January 19, 2017 at 9:26 am
I do not recommend this, but you can use the SET ANSI_WARNINGS command to turn them off. By default they are on. Please carefully read the documentation to...
January 19, 2017 at 9:24 am
January 19, 2017 at 9:20 am
Going...
January 18, 2017 at 2:16 pm
January 18, 2017 at 10:47 am
January 18, 2017 at 7:56 am
We're confusing two things here, a primary key, which is a column or columns that uniquely identify a row, and an identity column, which is a generated, monotonically increasing (although...
January 18, 2017 at 6:15 am
January 18, 2017 at 6:10 am
Wrote up an example blog post on this. It should be published about 10am Eastern. Here's the link.
January 18, 2017 at 6:07 am
January 16, 2017 at 8:04 am
Thank you for your time on this post and could you please elaborate your point....
January 14, 2017 at 9:23 am
January 14, 2017 at 9:19 am
I don't understand, the Subscriptions table is in the JOIN of the query.
January 13, 2017 at 11:11 am
Viewing 15 posts - 4,096 through 4,110 (of 22,211 total)