目的: 通过DB output 的数据, 自动生成 Insert SQL 语句

１、代码示例：

################################################################################################
# 标题: PowerShell : 连接字符串生成SQL语句
# 目的: 通过DB output 的数据, 自动生成 Insert SQL 语句 
# 1.按行读取文件，直到最后一行 
# 2.拼接字符串 
# 3.出力文件 
################################################################################################
# SQL插入语句模板
$sqlFormat = "INSERT INTO department(dno, dname, loc) VALUES("
# 入出力文件
$InputDate = "C:\wang\PowerShell\file\test\input.txt"
$OutputDate = "C:\wang\PowerShell\file\test\output.txt"
# 取得文件
$sku = Get-Content  $InputDate
# 按行读取文件
foreach  ( $skuLine  in  $sku ) {
     $newLine = -Join($sqlFormat, $skuLine, ");")
     # $newLine  =  $skuLine.Insert( $skuLine.Length, ");" )
     $newLine  >> $OutputDate
}

２、入力文件示 例：

'10', 'ENGINEERING', 'New York'
'11', 'ENGINEERING', 'New York'
'12', 'ENGINEERING', 'New York'
'13', 'ENGINEERING', 'New York'
'14', 'ENGINEERING', 'New York'
'15', 'ENGINEERING', 'New York'

３、出力文件示例：

INSERT INTO department(dno, dname, loc) VALUES('10', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('11', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('12', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('13', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('14', 'ENGINEERING', 'New York');
INSERT INTO department(dno, dname, loc) VALUES('15', 'ENGINEERING', 'New York');