SQL Not known Flashcards by Filip Grilec

Q

@@IDENTITY

A

returns the last-inserted identity value.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

SCOPE_IDENTITY()

A

Returns the last identity value inserted into an identity column in the same scope

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

IDENT_CURRENT( ‘table_name’ )

A

Returns the last identity value generated for a specified table or view.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly