![]() INSERT (SkillID, SkillName) VALUES (14, N'SQL') INSERT (SkillID, SkillName) VALUES (689, N'C#') SET NUMERIC_ROUNDABORT, IMPLICIT_TRANSACTIONS, XACT_ABORT OFF SET ARITHABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, NOCOUNT ON The T-SQL script is going to look the following way: SET DATEFORMAT ymd When the export is complete, you can either click “Finish” or open the folder with generated scripts by pressing the “Open result folder.” button:Īs a result, there will be 3 scripts generated for each directory table: But to make it simple, leave the default options and click “Export” to start exporting data. Note that users often select the “Write a report to a log file” option when they need to analyze the report results. Note that you can select all rows as well as an exact range of rows for data export.Īdditionally, you can configure errors handling parameters on the “Errors handling tab”. Then, click “Next”:įollowing that, on the “Exported rows” tab, select which data to export and press “Next”. ![]() Now, on the “Table columns” tab, you need to select the required columns and key fields for export (by default we select all columns for export, and the key fields match primary keys’ definitions of the corresponding tables).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |