Grant Collins wrote:
>
>
> Hi,
>
> Can anyone help me? I am doing a project using sql scripts. I am
trying to
> write a script that will insert data a number of times into a table.
Instead
> of just once at a time. Can anyone help me with this?
>
> Is there anyother way of putting data into table instead of the
> insert into <tablename> values (....);?
>
> Many thanks
>
> Grant
> collinz_at_clara.co.uk
>
> try this: Example==> Accept name Prompt 'Please enter the Name: '
Accept job Prompt 'Please enter the Job: '
(and so on......)
Insert into Emp
values('&name','&job');
I don't think there's another way of inserting data into a table without
using the ( INSERT into table_name VALUES ).
--
Posted via CNET Help.com
http://www.help.com/
Received on Sun Feb 04 2001 - 22:30:08 CST
