x

login about faq Site discussion (meta-askssc)

IDENTITY() .v. IDENTITY()

0

(Seeder)

While researching, I found that IDENTITY() can be a property of a table, as well as a function - under what circumstances can it be a function and why is it useful?

asked Apr 05 '10 at 06:51 PM in Default

Matt Whitfield ♦♦
29.2k ● 56 ● 63 ● 87

Good question..

Apr 05 '10 at 06:56 PM CirqueDeSQLeil

(comments are locked)

1 answer:

0

Identity() can be used as a function when populating a table with integer values to create a table of dummy data for testing. It must be used via the "Select Into" method. After which you should go back and recreate your indexes.

answered Apr 05 '10 at 06:55 PM

CirqueDeSQLeil
3.9k ● 8 ● 11 ● 15

Good answer... :)

Apr 05 '10 at 07:08 PM Matt Whitfield ♦♦

Thanks Matt. For others, this method is used widely throughout SSC.

Apr 05 '10 at 07:18 PM CirqueDeSQLeil

+1 to the hell of it:-)

Oct 05 '10 at 08:04 AM DaniSQL

Thanks Dani

Oct 05 '10 at 08:58 AM CirqueDeSQLeil

(comments are locked)

Your answer

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Topics:

identity x32
seeder-question x27

asked: Apr 05 '10 at 06:51 PM

Seen: 660 times

Last Updated: Apr 05 '10 at 06:51 PM

Related Questions

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.