insert identity table column value

Question

i have table propertybag, it's have only one identity coloumn

fo eg

   propertybagid identity(1,1)

i want to insert this value to this column one by one by query how?

plz reply soon

Madhivanan · Accepted Answer · 2010-07-26 12:53:06Z

4

Insert into propertybagid default values

answered Jul 26, 2010 at 12:53

Madhivanan

13.7k1 gold badge28 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Just a learner · Accepted Answer · 2010-07-28 11:10:41Z

1

INSERT T DEFAULT VALUES

Or to insert multiple rows (up to 2048 at a time using the spt_values table)

SET IDENTITY_INSERT t ON
INSERT INTO t (id) 
SELECT Number + COALESCE(IDENT_CURRENT('t'),0) + 1
FROM master.dbo.spt_values
where type='p' and number < 2048
SET IDENTITY_INSERT t OFF

answered Jul 28, 2010 at 11:10

Just a learner

29k54 gold badges169 silver badges250 bronze badges

Comments

Glenn · Accepted Answer · 2012-08-21 00:35:54Z

0

INSERT INTO <tablename> DEFAULT VALUES;

edited Aug 21, 2012 at 0:35

Glenn

9,2102 gold badges44 silver badges56 bronze badges

answered Jul 28, 2010 at 10:41

jay

3,9397 gold badges30 silver badges28 bronze badges

Collectives™ on Stack Overflow

insert identity table column value

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related