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

Use NorthwindSelect Insert Into Customer(CustomerID,CompanyName,ContactName)  Values (+ +CustomerID ++,+CompanyName++,+ContactName+) From Customers --------------------------
摘要由CSDN通过智能技术生成

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

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
以下是C# WinForm中将Excel数据导入到SQL Server数据库的步骤: 1. 需要添加对Microsoft.Office.Interop.Excel和System.Data.SqlClient的引用。 2. 建立一个Windows Form应用程序,并在单上添加一个按钮,用于触发导入Excel数据的过程。 3. 在按钮的Click事件编写代码,打开Excel文件并读取数据。 ```csharp using Excel = Microsoft.Office.Interop.Excel; Excel.Application excelApp = new Excel.Application(); Excel.Workbook workbook = excelApp.Workbooks.Open(@"C:\example.xlsx"); Excel.Worksheet worksheet = workbook.Sheets[1]; int rowsCount = worksheet.UsedRange.Rows.Count; int columnsCount = worksheet.UsedRange.Columns.Count; for (int row = 1; row <= rowsCount; row++) { for (int col = 1; col <= columnsCount; col++) { string cellValue = (worksheet.Cells[row, col] as Excel.Range).Value.ToString(); // Do something with the cell value } } workbook.Close(); excelApp.Quit(); ``` 4. 创建一个SqlConnection对象,用于连接到SQL Server数据库。 ```csharp using System.Data.SqlClient; SqlConnection connection = new SqlConnection("Data Source=serverName;Initial Catalog=databaseName;Integrated Security=True"); connection.Open(); ``` 5. 创建一个SqlCommand对象,用于执行插入语句。 ```csharp SqlCommand command = new SqlCommand("INSERT INTO TableName (Column1, Column2) VALUES (@Value1, @Value2)", connection); command.Parameters.AddWithValue("@Value1", cellValue1); command.Parameters.AddWithValue("@Value2", cellValue2); command.ExecuteNonQuery(); ``` 6. 在循环使用SqlCommand对象插入数据。 7. 关闭SqlConnection对象。 ```csharp connection.Close(); ``` 完成以上步骤后,您的C# WinForm应用程序就能够将Excel数据导入到SQL Server数据库了。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值