Re: How to insert auto increment?

On Tue, 4 Apr 2006 13:16:01 -0700, MN wrote:

Hi Expert,
How can I do this without enter 100 time every day?

insert into [tablename] (column1) values(1)
insert into [tablename] (column1) values(2)
....
insert into [tablename] (column1) values(100)
Thank you all for reply-MN

Hi MN,

I'd very much like to know why you need to do that.....

But the asnwer is: make a permanent table of numbers in your database
(see http://www.aspfaq.com/show.asp?id=2516), and use that:

INSERT INTO tablename (column1)
SELECT Numbers.Number
FROM dbo.Numbers
WHERE Numbers.Number BETWEEN 1 AND 100

--
Hugo Kornelis, SQL Server MVP
.

Relevant Pages

  • Re: select field contain chr(10) (Line Feed character) usng T-SQL
    ... SELECT column1 ... FROM table1 ... Hugo Kornelis, SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)
  • Re: How to insert auto increment?
    ... insert into [tablename] (column1) values ... State what version of SQL Server you are using and specify the content ...
    (microsoft.public.sqlserver.mseq)
  • Re: using the Execute statement including variables
    ... see http://www.sommarskog.se/dynamic_sql.html for dynamic SQL ... SQL Server MVP ... > SELECT * from @TableName doesn't work unless I do something like this ... > The EXEC statement doesn't accept variable. ...
    (microsoft.public.sqlserver.server)
  • Re: Violation of UNIQUE KEY
    ... where Column1 like '0%' ... > SQL Server MVP ... >> Update Table1 ...
    (microsoft.public.sqlserver.programming)
  • Re: Data checking problem...
    ... SELECT * FROM tablename where lastname NOT LIKE '%%' ... strange characters or whathaveyou). ... > SQL Server MVP ... >> I'm not too keen on creating a plethora of sql tasks to ...
    (microsoft.public.sqlserver.dts)