文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>BCP

BCP

时间:2011-04-07  来源:狐狸精

1.Handles Data in Native Format

EXEC master..xp_cmdshell 'bcp "[HopsDW].[dbo].[FactClickUDC_ALL]" out d:\01.dat -S . -T   -n '

EXEC master..xp_cmdshell 'bcp "[HopsDW].[dbo].[ALL]" in d:\01.dat -S .  -T   -n '

2.Performs the operation using a character data type. This option does not prompt for each field
EXEC master..xp_cmdshell 'bcp "[HopsDW].[dbo].[FactClickUDC_ALL]" out d:\01.dat -S . -T   -c '

EXEC master..xp_cmdshell 'bcp "[HopsDW].[dbo].[ALL]" in d:\01.dat -S .  -T   -c '


3.Performs the bulk-copy operation using the native (database) data types of the data for noncharacter data, and Unicode characters for character data.
EXEC master..xp_cmdshell 'bcp "[HopsDW].[dbo].[FactClickUDC_ALL]" out d:\01.dat -S . -T   -N '

EXEC master..xp_cmdshell 'bcp "[HopsDW].[dbo].[ALL]" in d:\01.dat -S .  -T   -N '

Notes:

-T :Specifies that the bcp utility connects to SQL Server with a trusted connection using integrated security.



 

相关阅读 更多 +
排行榜 更多 +
立体反应点击

立体反应点击

休闲益智 下载
料理物语

料理物语

休闲益智 下载
滑杆优雅舞者

滑杆优雅舞者

休闲益智 下载