Try this

sri sri replied to Arvind M at 05-Jul-08 02:28
Hi,
Create a for loop and
call the insert procedure in the loop

create procedure Proc_Insert
(
  @Name as nvarchar(25),
   @Age as int,
   @Address as nvarchar(100),
   @City as nvarchar(100)
)
as
Begin
      insert into Employee (Name,Age,Address,City) values (@Name,@Age,@Address,@City)
End

Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  insert new record in database - Arvind M  05-Jul-08 01:59 1:59:08 AM
      See this - Sujit Patil  05-Jul-08 02:16 2:16:18 AM
          re:See this - Arvind M  05-Jul-08 02:24 2:24:57 AM
              Try this - sri sri  05-Jul-08 02:28 2:28:56 AM
              Use LOOP - Sujit Patil  05-Jul-08 03:17 3:17:24 AM
      Insert new record in database - Sanjay Verma  05-Jul-08 02:44 2:44:25 AM
      solution to insert new record in database - Umapathy Kaliaperumal  05-Jul-08 02:49 2:49:26 AM
      Reply - alice johnson  05-Jul-08 03:20 3:20:32 AM
      use Bulkcopy - Vasanthakumar D  05-Jul-08 04:18 4:18:41 AM
      u can do this using xml - Arvind Kumar  07-Jul-08 01:20 1:20:01 AM
View Posts