Using Seqence Container instead of Identity

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

leonmccalla SSC Rookie Points: 33 More actions · Answer 1

its a "SEQUENCE OBJECT" not a "SEQUENCE CONTAINER".

Leon

pawel.sowka SSC Eights! Points: 851 More actions · Answer 2

I got an error:

Type dbo.HVCIDdt is not a defined system type.

WHY?

filipecosta Grasshopper Points: 12 More actions · Answer 3

I think [HVCIDdt] is a user data type (just like Int or BigInt), we are supposed to create, but the tsql in the post does not have.

If you change [HVCIDdt] for [BigInt], the script works.

See details here.

Craig A. Silvis Ten Centuries Points: 1038 More actions · Answer 4

Or you could create the user type -

CREATE TYPE [dbo].[HVCIDdt]

FROM bigint NOT NULL ;

unladenswallow SSC Enthusiast Points: 134 More actions · Answer 5

I don't think you need the TOP 1 in the existence tests. EXISTS (SELECT...) already has the optimization of stopping after the first row built in.

Brian J. Parker SSC Eights! Points: 879 More actions · Answer 6

This is a feature added in SQL Server 2012; that might be the problem for pawel.sowka.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

Brian J. Parker (3/24/2014)
This is a feature added in SQL Server 2012; that might be the problem for pawel.sowka.

Oh, that's why I don't know about it.