I wrote store rpocedure i want to check data saved then need to insert

Question

if condition check if DATABASEPROPERTY is saved in [DataConsumerMaster]  table for dept then

insert record in logins table and from procedure return id name pwd saved

 

 

lije this i want