Sql insert into

Reply

Join Date: Sep 2006
Posts: 65
Reputation: arvin2006 is an unknown quantity at this point 
Solved Threads: 4
arvin2006's Avatar
arvin2006 arvin2006 is offline Offline
Junior Poster in Training

Sql insert into

 
0
  #1
Feb 19th, 2009
hi everyone, i just want to ask if it is possible for the SQL INSERT INTO to LOOP? for example, insert new records in TABLE ten times with the same values (colum1,column2,column3,etc..) is there an alternative way instead of typing (INSERT INTO.. 10x) statement repeatedly. thanks.
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 509
Reputation: selvaganapathy is an unknown quantity at this point 
Solved Threads: 88
selvaganapathy's Avatar
selvaganapathy selvaganapathy is offline Offline
Posting Pro

Re: Sql insert into

 
0
  #2
Feb 20th, 2009
Hi,

I dont think so such query exist but u can use like this

  1. INSERT INTO VALUES ( .... ) , ( .... ) , ....

Make such SQL and Execute the single query.
KSG
Reply With Quote Quick reply to this message  
Join Date: Feb 2007
Posts: 2,091
Reputation: debasisdas will become famous soon enough debasisdas will become famous soon enough 
Solved Threads: 125
debasisdas's Avatar
debasisdas debasisdas is online now Online
Postaholic

Re: Sql insert into

 
0
  #3
Feb 21st, 2009
you can use loop inside a sub program for the purpose.
Share your Knowledge.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC