Insert Table Rows using Parameterized Queries | Teradata Studio/Studio Express - Inserting Table Rows using Parameterized Queries - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
ztp1648839236373.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities
When you execute the SQL, you are prompted to use the default values, or specify the values for each of the parameter placeholders to specify constraints.
  1. In the Data Source Explorer, navigate to the database table in which you want to insert rows.
  2. Right-click the table object and select one of these options:.
    For Select
    Vantage Teradata > Generate SQL > INSERT (Parameterized) Statement
    Aster Database Aster > Generate SQL > INSERT (Parameterized) Statement
  3. In the SQL Editor, review the generated INSERT statement and edit as needed.
  4. Click to execute the INSERT statement.
  5. In the Configure Parameters dialog, specify the values for each of the parameters or click Load Default to specify default values.
  6. Click OK.