0

I have below PowerShell logic to copy the data. Now we are moving this logic to the Angular application.

So, I want to save this data in the database table. Could you please advise how can I store them?

In the application, if the user selects the country value, then it should automatically populate the State, Outlook, and Teams Column

if (country -eq "US") {
    $State = "Yes"
    $outlook = "Office 365"
    $Teams = "Office 365"
}
elseif (Country -eq "UK") {
    $state = "NO"
    $outlook = "Exchange"
    $team = Skype
}
Improve this question
3
  • Uhm, lookup means reading data but you're talking about saving stuff. Take a look at Connect to SQL Server Database from PowerShell to get an idea. To provide an actual answer we should get more information. Commented Dec 5, 2020 at 20:41
  • "In the application, if the user selects the country value, then it should automatically populate the State, Outlook, and Teams Column" Have you worked out how you implement this in Angular? Angular is worlds apart from Powershell. Also there is a whole world of data modelling questions here. Do you have a lot of different "Outlook" and "team" settings? Commented Dec 6, 2020 at 2:19
  • Yes. We have many data which we pull from CSV file. Can I create the same structure in DB Commented Dec 7, 2020 at 6:31
Related questions
0
Creating a SQL lookup
3
SQL SELECT statement when using look up table
0
generate dropdown list for sql server db management
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.