Reading the following should help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

And if you really insist, then the following example should give you an idea:

declare @n int

set @n = 5 -- I want my inserts start from 5

create table #t (id...

Don't use identity, use ROW_NUMBER() instead. You can start counting from any requested value...

In 2008 and after you can do:

insert into table1 (column1, column2,column3)

select column1,column2,n

from table2, (values (1),(2)) q(n)

...i have a code which was written in Vb.net for migration of data,so my client dont need that type of coding he wants in either...

Poor kids... :w00t:

I only can guess which first book you make them to read, it must be ISO standards. Following...

nguyenhoang 18993 (5/17/2012)

---

how are you determining that the trigger did not fire ? - have you run a profiler trace to determine the data that was inserted?

No! if I action...

It can be done using "Quirky Update" method.

Read this great article by J. Moden: http://www.sqlservercentral.com/articles/T-SQL/68467/

Try type 200 instead of 201.

have you changed the server code which talks to DB? Or, if you are using stored proc, have you change the parameter definition there?

...

The reason I say that Microsoft has a lot to answer for is this: The default-to-clustered "feature" achieves nothing much for wise developers but its unintended consequence is that too...

Yeah, but it will only work for known values.

It's as well as doing it manually...

I love it!

declare @t table (id int identity(1,1), val varchar(200))

insert @t

select 'OO27k Informed Consent from Persons with Limited'

union select 'OO27l Expedited Review'

union select 'OO27m IRB...

Removing all digits may not help for cases like:

OO1a 2011 Zero

OO1a 2012 Non-Zero

as OP, if I understand correctly, would want to sort them as above, and stripping digits would sort...

It would make full sense, if you could show the exact expected result based on your sample. It would help to understand how you want your data...