A good man reached out to me and prepped me about an upcoming Change Request.
The Change will be to add a lone record.
Here are a couple of options:
- Have him add it to Development / QA
- I will use Linked Server to bring it over to Production
- Create corresponding SQL Statements and apply generated SQL
- Generate Data
- SQL Query
- Review Data Pane
- Select Data Rows
- Using menu, access “Generate SQL”\”Insert”
Depending on your needs, choose to generate data against the selected table or view. Or write a custom SQL.
If it will expedite your needs, please choose a table, view, function, or Stored Procedure.
When table or view, please right click on the selected object and choose “Edit data”.
Enter SQL Query
SQL Query – Text
select * from WideWorldImportersDW.Dimension.City
SQL Query – Image
Review Data Pane
Here is Generated data
Data Pane – Select Data Rows
In the Data Pane, please select the data rows.
Data Pane, Generate SQL/Insert
Right click on the selected records and choose to generate SQL/Insert.