Posted by Erland Sommarskog on 10/02/78 11:56

Hugo Kornelis (hugo@perFact.REMOVETHIS.info.INVALID) writes:
> 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

IF (SELECT COUNT(*) FROM #ten) < 1000 OR
(SELECT MIN(id) FROM #ten) <> 1 OR
(SELECT MAX(id) FROM #ten) <> 1000
BEGIN
RAISERROR ('Fill of #ten failed!', 16, 1)
RETURN 1
END

That is, I don't think one should trust the code above to always return
what you looking for. Adding some paranoia can avoid incorrect results.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Setting up scheduled jobs for different days with different intervals
• Prev in forum: Re: SQL Server 2005 Opening Script File Problem
• Thread view: Re: Case help and Identity help

[Reply to this message]