Preview SQL Script Dialog Box

This dialog box displays the Transact-SQL statements that will be executed when using a wizard to create new stored procedures to read and write data. The script displayed in the box is the script that the wizard has generated to create the four stored procedures for the adapter's Select, Update, Insert, and Delete commands.

For more information about SQL scripts, refer to the documentation for SQL Server.

User Interface Element List

  • Save As
    Saves the entire SQL script as a text file (by default, with an .sql extension). SQL script files can be run in SQL Server to create new stored procedures.

  • Copy All
    Copies the entire SQL script to the Clipboard. You can then paste it in a text editor for further editing.

  • Close
    Closes this dialog box and returns you to the wizard.

See Also

Tasks

How to: Create TableAdapters

How to: Create TableAdapter Queries

Reference

TableAdapter Configuration Wizard

TableAdapter Query Configuration Wizard

Concepts

TableAdapter Overview