Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 ID in view

Author  Topic 

sfunds
Starting Member

7 Posts

Posted - 2006-01-28 : 12:04:04
Hi,
Is it possible to have id (auto increment) in a view created
Thanks

nathans
Aged Yak Warrior

938 Posts

Posted - 2006-01-28 : 14:11:34
Refer this page for some ideas of adding rowid equivalent to your query:

http://www.sqlteam.com/item.asp?ItemID=1491

Nathan Skerl
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2006-01-28 : 17:19:48
quote:
Originally posted by sfunds

Hi,
Is it possible to have id (auto increment) in a view created
Thanks


Why would you want that?

_______________________________
logic is logical within context

rockmoose
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-01-29 : 04:46:10
"Why would you want that?"

Yeah ... knowing the problem-to-be-solved would help in suggesting solutions

Kristen
Go to Top of Page

cspooner
Starting Member

2 Posts

Posted - 2006-02-15 : 05:28:29
quote:
Originally posted by Kristen

"Why would you want that?"

Yeah ... knowing the problem-to-be-solved would help in suggesting solutions

Kristen



Go to Top of Page

cspooner
Starting Member

2 Posts

Posted - 2006-02-15 : 05:30:12
quote:
Originally posted by cspooner

[quote]Originally posted by Kristen

"Why would you want that?"

Yeah ... knowing the problem-to-be-solved would help in suggesting solutions

Kristen




I have a similar problem and I need to create and AutoIncrementing integer ID for another program called ArcMap to be able to access. ANyonw got any ideas for doing this in SQL 2000 ?
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-15 : 06:21:48
Where do you want to show those Autonumbers?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -