SQL Server Performance

how to add identity column to a view in sql server 2000

Discussion in 'SQL Server 2005 General Developer Questions' started by mpolaiah, Jul 7, 2008.

  1. mpolaiah New Member

    hi all,
    how to add identity column to a view in sql server 2000.
    plz help.
  2. FrankKalis Moderator

    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.
  3. satya Moderator

    Hope you got reference from Frank's reply, for more clarification I want to ask why you want to do that way?

Share This Page