SQL Server Exports table data as an INSERT statement

From the Internet to find the method, but very good, recorded, but also to share the next ~ ~

There is a table, city, with columns: cityid,cityname; change all data in this table to insert statement

Select ' Insert into TableName (cityid,cityname) VALUES (' ' +cityid+ ' ", ' +cityname+ ') ' as sqlstr from the city;

So that it can be done;

If there are other types in the column, so the write will be error, you can use this method to convert, STR (Cityid,len (Cityid)), so you can;

Of course, Oracle doesn't have to, and this feature is available in PL/SQL (*^__^*)

SQL Server Exports table data as an INSERT statement