Our Training Programs

All contents are copyright of their authors.

identity column in table

identity column in table

Ani

9yAsked Jul 24, 2017, 7:05 AM815Learn iOS Programming

hi,

I have bulk data and i have insert them into a new table with identity column like as below

identity row should be A1 for first 100 rows, A2 for second 100 rows, A3 for third 100 rows, etc...........

Please help me

Thanks,

Ani

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

saida chary9y ago
hi,
Insert Id for new table from old table
Insert Into (Id) values(
select 'A'+Convert(varchar,ID/100+1) from )
Rafnas T P9y ago
try like this in your insert statement instead of that column value add this line

case when (select count(*) from yourtablename)<=100 then 'A1'
when (select count(*) from yourtablename)<=200 then 'A2' when (select count(*) from yourtablename)<=300 then 'A3 'end
Rafnas T P9y ago
well you can do it through looping, but you can not use this as primary key,or identity key
Ani9y ago
Hi Rafnas,

Thanks for your suggestion.
Please let me know is there any way to do it without identity column and primary key.

Thanks,
ani
Rafnas T P9y ago
hi,
first of all, Identity column will no insert same value more than once,
here you mentioned that you want identity column value A1 for first 100 rows
like
A1
A1
.
.
100 times
this is not possible for identity column or primary key column