Posted by cmm on 12/27/05 15:46
I am trying to create a view in MSSQL that has a column which is an
auto increment (or unique id) field but it doesn't work the way I want
it. Does anybody have an idea how to do this? The example below gives
me only 0 in the id field.
CREATE VIEW dbo.tree_x_categories
AS
SELECT @@ROWCOUNTas id, *
FROM <dbname>.dbo.tree_x_categories
GO
What I want is the fields from the table tree_x_categories plus an
additional field that has a unique identifier.
Many thnx,
Chris
[Back to original message]
|