Myujth

How do I insert data into several tables each with different types and number of parameters. e.g

Table1

Code Type
'A' X

Table 2

Code Type Status Dasl

Here the number of parameters are different.

In this case how to insert the data into tables using a common stored procedure.

Create sample stored procedure to get an idea how to save data into records.
Create Table Type like below to insert multiple records in to your database

CREATE TYPE [dbo].[tbl_Table2] AS TABLE(
 [Code] [char](2) NULL,
 [Type] [char](2) NULL,
 [Status] [varchar](5) NULL,
 [Dasl] [varchar](5) NULL
)
GO

CREATE PROCEDURE [dbo].[Usp_DataInsert] 
(
@Code CHAR(2),
@Type CHAR(2),
@tbl_Table2 AS tbl_Table2 READONLY
)
AS 
BEGIN TRY 

 IF EXISTS(SELECT 1 FROM @tbl_Table2)
 BEGIN 
 INSERT INTO Table2
 (
 Code
 ,[Type]
 ,[Status]
 ,Dasl
 )
 SELECT Code
 ,[Type]
 ,[Status]
 ,Dasl 
 FROM @tbl_Table2
 END
 INSERT INTO Table1
 (
 Code,
 [Type]
 )
 SELECT @Code,@Type

END TRY
BEGIN CATCH
 DECLARE @ErrorMessage NVARCHAR(4000);
 DECLARE @ErrorSeverity INT;
 DECLARE @ErrorState INT;

 SELECT 
 @ErrorMessage = ERROR_MESSAGE(),
 @ErrorSeverity = ERROR_SEVERITY(),
 @ErrorState = ERROR_STATE();

 RAISERROR (@ErrorMessage, -- Message text.
 @ErrorSeverity, -- Severity.
 @ErrorState -- State.
 );
END CATCH;

Insert data into table through stored procedure

DECLARE @RC int
DECLARE @Code char(2)='Z'
DECLARE @Type char(2)=33
DECLARE @tbl_Table2 tbl_Table2

INSERT INTO @tbl_Table2
SELECT 'A','X','A','AB' UNION ALL
SELECT 'A','X','A','AB' UNION ALL
SELECT 'A','X','A','AB' UNION ALL
SELECT 'A','X','A','AB' 

EXECUTE @RC = [dbo].[Usp_DataInsert] 
 @Code
 ,@Type
 ,@tbl_Table2
GO

You need to use different stored procedures to insert with multiple tables with different parameters, You can use transaction from front end also