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