Discussion in 'SQL Server 2005 General Developer Questions' started by mpolaiah, Jul 7, 2008.
how to add identity column to a view in sql server 2000.
You can't use a "virtual column" with the identity property in a view. Either this view acesses a temp table with an identity column or you perform some query tricks to mimic such a column (which would be really slow fo larger resultsets) or, even better, use your presentation tool to add such a running number.
Hope you got reference from Frank's reply, for more clarification I want to ask why you want to do that way?
Separate names with a comma.