See if this helps: http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

Thanks for explaining. Sounds cooler than "I can't believe this is happening to me (or us in this case".

Bear with me, but what does "Aye, Yi Yi" mean?

No shortcut here. And that's good so. Here are some thought on this from SQL Server MVP Kenneth Wilhelmsson:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=158711

For the records, here are some more examples of this parsing trick:

http://vyaskn.tripod.com/fun_with_numbers_in_t-sql_queries.htm

I doubt whether you will find much help around here. SQL Server pros aren't going to be willing to help people "blag" a job in their profession because it kinda belittles...

ALTER TABLE YourTableNAME

ALTER COLUMN SerialNo int identity (1,1) not null

Go

Interesting script. Do you think it will work?

Not directly what you asked for, but maybe these tools will help you somehow

http://www.microsoft.com/downloads/details.aspx?FamilyID=5691ab53-893a-4aaf-b4a6-9a8bb9669a8b&DisplayLang=en

http://www.microsoft.com/technet/archive/itsolutions/intranet/downloads/webstres.mspx

Glad I could help.

...oops, forgot to mention. It works also in EM. You only need to refresh the view.

Are you trying this from within EM???

This works fine for me with QA:

CREATE TABLE [dbo].[Table1] (

 [c1] [int] NOT NULL ,

 [c2] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[Table1]...

First, let me say, that the INT value of today is *not* 38390! Since we are now past 12:00:00 some methods round up which isn't correct. So, the correct value is...

Welcome here!

You asked a FAQ which is best explained here:

http://www.sommarskog.se/dynamic_sql.html

Hm, in this case I'll second Remi.

See if this helps:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=155613