SQL query or proc

jayu p

4y978SQL

I want to insert into two tables from one table based on vlaue on sourcestring value as per type, like if 'protection' then in protection table else in 'configuration' table

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Srinivasan Ramamoorthi4y ago
Accepted answer
You can write a stored procedure with cursor and if condition. I won’t recommend doing this with query. Later you can enhance the procedure to add more logic or include transaction support and exception handling.
Siddhant panda4y ago
noramally also possible if use stored procedure then its better .
if you want stored procedure program then comment in down then i wiil help you.
Sachin Singh4y ago
Better is to automate the thing.
Create an afterInsert trigger on your StringTranslation table.
USE [SQL Tutorial]
GO
CREATE TRIGGER AfterINSERTTrigger on [StringTranslation]
FOR INSERT
AS DECLARE @ID INT,
           @SourceString varchar(MAX)
       @OS VARCHAR(50),
       @Type VARCHAR(50),
       @Modified DateTime,
       @ModifiedBy Varchar(250),

SELECT @ID = ins.ID FROM INSERTED ins;
SELECT @SourceString = ins.SourceString FROM INSERTED ins;
SELECT @OS = ins.OS FROM INSERTED ins;
SELECT @Type = ins.Type FROM INSERTED ins;
SELECT @Modified = ins.Modified FROM INSERTED ins;
SELECT @ModifiedBy = ins.ModifiedBy FROM INSERTED ins;

if(SourceString='#microsoft.graph.android.ManagedAppProtection')

INSERT INTO [TableAudit1]

VALUES (@ID,
    @SourceString ,
    @OS ,
    @Type ,
    @Modified ,
    @ModifiedBy ,
);
else
INSERT INTO [TableAudit2]

VALUES (@ID,
    @SourceString ,
    @OS ,
    @Type ,
    @Modified ,
    @ModifiedBy ,
);
Jignesh Kumar4y ago
Hi Jayu,

I would suggest, You should go with Store procedure. If you go with Inline query then you need to do code change every time and need to deploy your code for minor change as well.