Posted by Hugo Kornelis on 10/02/55 11:56

On 23 Aug 2006 12:14:02 -0700, mutemode@gmail.com wrote:

(snip)
>AND
>
>I need to get the numbers 1-1000 into a table called #thousand using
>the identity function. Help?

Hi mutemode,

SELECT TOP 1000 IDENTITY(int, 1,1) AS id
INTO #ten
FROM sysobjects AS a, sysobjects AS b


--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Help me with this query please.
• Prev in forum: Re: User authentication
• Thread view: Re: Case help and Identity help

[Reply to this message]