如何使用PowerShell从SQL Server将数据写入平面文件 [英] How to write data into flat file from SQL server using powershell

问题描述

我们有2个桌子桌子：ApplePhone和AppleGear

桌面结构：ApplePhone

Id电话

1 6s

2 7s



桌面结构：AppleGear

Id Gear

1耳朵

2手表



现在我们需要将上面的表数据写入平面文件中分隔符。

2 O / p文件应该是：

ApplePhone.dat

Id |电话

1 | 6s

2 | 7s



AppleGear.dat

Id | Gear

1 |耳朵

2 |观看



如果有人已经有代码片段，请帮助我们。



我尝试了什么：



到目前为止我们提出了这个代码：

We have 2 tables Tables : ApplePhone and AppleGear
Table Structure:ApplePhone
Id Phone
1 6s
2 7s

Table Structure:AppleGear
Id Gear
1 ear
2 watch

Now we need to write the above table data into flat files with | delimiter.
2 O/p File should be:
ApplePhone.dat
Id|Phone
1|6s
2|7s

AppleGear.dat
Id|Gear
1|ear
2|watch

Please help us with this if anyone has already has a code snippet.

What I have tried:

So far came up with this code:

$SQLServer = 'myServer';
$Database = 'AppleDB';
$SqlQuery = @'
Select Id,Phone FROM [AppleDB].[dbo].[ApplePhone]
'@;

现在不知道怎么办。这个脚本世界的新手。

Don't know how to proceed now. Newbie to this scripting world.

推荐答案

SQLServer ='myServer';

SQLServer = 'myServer';

Database ='AppleDB';

Database = 'AppleDB';

SqlQuery = @'
选择ID，电话来自[AppleDB]。[dbo]。[ApplePhone]
'@;

SqlQuery = @' Select Id,Phone FROM [AppleDB].[dbo].[ApplePhone] '@;

现在不知道怎么办。这个脚本世界的新手。

Don't know how to proceed now. Newbie to this scripting world.

这篇关于如何使用PowerShell从SQL Server将数据写入平面文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！