SQL Server table data exported as INSERT INTO statement

<1>select ' INSERT INTO table_name (NAME,CODE) VALUES (' ' +name+ ' ', ' ' +code+ '); "Sql_str from Canton;

<2> for processing with an ID of type int

Select ' INSERT INTO table_name (ID,CODE) VALUES (' +cast (id as varchar) + ', ' ' +code+ ' "); ' Sql_str from Canton;

<3> for more field handling, see attachment stored procedures [Table_insert]

<4> database field name has a keyword, you want to replace it with [column]

SQL Server table data exported as INSERT INTO statement