Insert values x into table A if exist on table B

Question

Insert values x into table A if exist on table B

Asked 3 years, 2 months ago

Viewed 53 times

-1

I want to Insert in table A of the key field, but only if this key already exists in table B

Example Insert key(123) in table B if there is key(123) in table a

(am using sql procedures managemente studio)

    ALTER procedure [dbo].[InsertHeartRate]
(

    @TimeStamp datetime = '',
    @Value varchar(3) = '',
    @MacAddress varchar(30) = ''
)
as
BEGIN
    Insert into HeartRate (TimeStamp,Value,MacAddress)
    Select @MacAddress
    where (Select @MacAddress
                From banda
                where MacAddress= @MacAddress);
    Values(@TimeStamp,@Value,@MacAddress)
    
END

I’m trying to change the process, but with difficulties, the key would be the macaddress

1

This answers your question? How to Insert into the table if the record does not exist

– Ricardo Pontual

2021/04/20 at 10:41
thanks, but no, I want to insert in the tebela a, but only when the key 123 ja EXIST in table b.

– Drakan x

2021/04/20 at 11:17
1

and isn’t that what the answer shows but with a "no" exist? if you take the not that has in the not exists will not do exactly what you want?

– Ricardo Pontual

2021/04/20 at 11:29
yes I thought about this option, but if the value does not exist it lets insert?

– Drakan x

2021/04/20 at 11:40
do a test :) also, put in your question a tag with the database you are using

– Ricardo Pontual

2021/04/20 at 11:55

1 answer

Browser other questions tagged c# sql-server visual-studio procedure

You are not signed in. Login or sign up in order to post.

by imex • **1,387** points · Answer 1 · 2021-04-20T13:36:05+00:00

Good morning,

Here is a suggestion for testing:

Insert into HeartRate (TimeStamp, Value, MacAddress)
    Select top(1) @TimeStamp, @Value, @MacAddress
    From banda
    where MacAddress = @MacAddress

Select will only return some data if there is a row in the Band table with the value of the parameter for the Macaddress column, and no row will be inserted if no data is returned. And you can remove the top(1) if there is always only one row in the Band table for each Macaddress.

I hope it helps