mercredi 4 mars 2015

how to make data insert into multiple tables with all the tables are having same column name using singles sql stored procedure


I have four tables, in all the four tables i have similar column, now i want to make entry into each table at a time using single stored procedure


i have created user defined table


CREATE TYPE dbo.tbluserdefined AS TABLE ( SlNo nvarchar(50), [Source] nvarchar(50),Destination nvarchar(50),SourceID nvarchar(50),DestinationID nvarchar(50),BusID nvarchar(50),Operator nvarchar(50),TravelsName nvarchar(50),DepartureTime nvarchar(50),DepTimeMinute nvarchar(50),ArrivalTime nvarchar(50),ArrTimeMinute nvarchar(50),Duration nvarchar(50),SeatsAvilable nvarchar(50),SeatFare nvarchar(50),BusType nvarchar(50),TravelDate nvarchar(50),UpdatedOn nvarchar(50) ) GO


stored procedure to insert


CREATE PROCEDURE [dbo].[Insert_Routestable] @tblRoutes dbo.tbluserdefined READONLY AS BEGIN SET NOCOUNT ON; INSERT INTO dbo.tbl_RoutesUpdate_Bitla(SlNo, [Source],Destination ,SourceID ,DestinationID,BusID ,Operator,TravelsName ,DepartureTime,DepTimeMinute,ArrivalTime ,ArrTimeMinute ,Duration,SeatsAvilable ,SeatFare ,BusType,TravelDate,UpdatedOn ) SELECT SlNo, [Source],Destination ,SourceID ,DestinationID,BusID ,Operator,TravelsName ,DepartureTime,DepTimeMinute,ArrivalTime ,ArrTimeMinute ,Duration,SeatsAvilable ,SeatFare ,BusType,TravelDate,UpdatedOn FROM @tblRoutes END


i want data to be inserted into one table at a time, is there any solution for this, kindly help





Aucun commentaire:

Enregistrer un commentaire