带有select查询的sql server中的BCP

时间:2022-09-20 23:31:51

i want to take the data from select query to txt or csv formate with comma separated in sql server 2008

我想把选择查询中的数据带到txt或csv formate,在sql server 2008中用逗号分隔

1 个解决方案

#1


0  

You Can use SSIS if this is going to be a scheduled or repeating requirement. But If this is just a one-time requirement then probably the Import Export Wizard that comes along the SSMS will be enough.

如果这是一个计划或重复的要求,您可以使用SSIS。但如果这只是一次性要求,那么SSMS附带的导入导出向导就足够了。

Check The Below Links :

检查以下链接:

Using SSIS

Using Import Export Wizard

使用导入导出向导

#1


0  

You Can use SSIS if this is going to be a scheduled or repeating requirement. But If this is just a one-time requirement then probably the Import Export Wizard that comes along the SSMS will be enough.

如果这是一个计划或重复的要求,您可以使用SSIS。但如果这只是一次性要求,那么SSMS附带的导入导出向导就足够了。

Check The Below Links :

检查以下链接:

Using SSIS

Using Import Export Wizard

使用导入导出向导