摘要：
1.启动PowerShell在数据库的实例名上右击，选择"启动PowerShell"2.输入命令PS SQLSERVER:\SQL\LENOVO-PC\DEFAULT> bcp YLBX兰考.dbo.ff out e:/123.xls -c -q -S"LENOVO-PC" -U "sa" -P "lvyafei"开始复制...1000 rows successfully bulk-copied to host-file. Total received: 10001000 rows successfully 阅读全文
摘要：
select P_CommunityID from T_Person group by P_CommunityID//创建游标declare sc cursor scroll for select P_CommunityID from T_Person group by P_CommunityIDopen scfetch first from sc close scdeallocate sc//使用游标declare @i intfetch first from sc into @iwhile @i!=541begininsert into ffselect TOP 76 * from T_P 阅读全文
