摘要： 跨服务器读写数据时报错：select * from opendatasource('SQLOLEDB','Data Source=173.02.01.102;Initial Catalog=testdb;User ID=sa;PWD=123;').testdb.dbo.ATCEdit2报错内容是：SQL Server 阻止了对组件 'Ad Hoc Distributed Queries' 的 STATEMENT'OpenRowset/OpenDatasource' 的访问，因为此组件已作为此服务器安全配置的一部分而被关闭。系统管理 阅读全文

摘要： --删除重复数据select distinct * into #Tmp from ewf_sys_user drop table ewf_sys_user select * into ewf_sys_user from #Tmp drop table #Tmp--删除重复数据(对于distinct *还是重复的表)select *,row_number() over(order by userid ) as rowid into #t from ewf_sys_user where userid in (select userid from ewf_sys_user group by user 阅读全文