SQL Server 数据库中将数据表中的数据转化为Insert 语句-优快云博客

本文链接：https://blog.youkuaiyun.com/striveman/article/details/1612577

本文展示了如何在SQL Server中使用SQL查询将数据表`Customers`的数据转化为INSERT语句，便于创建数据导入脚本。查询结果生成了一系列INSERT语句，用于插入新的Customer记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Use Northwind
Select 'Insert Into Customer(CustomerID,CompanyName,ContactName)
Values ('+'''' +CustomerID +''''+','''+CompanyName+''''+','''+ContactName+''')' From Customers
----------------------------------------
查询后，得到的结果为：
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('ALFKI','Alfreds Futterkiste','Maria Anders')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('ANATR','Ana Trujillo Emparedados y helados','Ana Trujillo')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('ANTON','Antonio Moreno Taquería','Antonio Moreno')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('AROUT','Around the Horn','Thomas Hardy')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('BERGS','Berglunds snabbköp','Christina Berglund')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('BLAUS','Blauer See Delikatessen','Hanna Moos')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('BLONP','Blondesddsl père et fils','Frédérique Citeaux')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('BOLID','Bólido Comidas preparadas','Martín Sommer')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('BONAP','Bon app'','Laurence Lebihan')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('BOTTM','Bottom-Dollar Markets','Elizabeth Lincoln')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('BSBEV','B's Beverages','Victoria Ashworth')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('CACTU','Cactus Comidas para llevar','Patricio Simpson')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('CENTC','Centro comercial Moctezuma','Francisco Chang')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('CHOPS','Chop-suey Chinese','Yang Wang')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('COMMI','Comércio Mineiro','Pedro Afonso')
Insert Into Customer(CustomerID,CompanyName,ContactName)    Values ('CONSH','Consolidated Holdings','Eliz