文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
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.



 

相关阅读 更多 +
排行榜 更多 +
幸存者的命运

幸存者的命运

飞行射击 下载
精英战区3d

精英战区3d

飞行射击 下载
货运猎人

货运猎人

飞行射击 下载