SQL Server 数据库中将数据表中的数据转化为Insert 语句

最新推荐文章于 2021-11-19 14:50:31 发布

原创

最新推荐文章于 2021-11-19 14:50:31 发布 · 6.3k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#insert #sql server #数据库 #import #脚本 #sql

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

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','Elizabeth Brown')
Insert Into Customer(CustomerID,CompanyName,ContactName)

最低0.47元/天解锁文章