`

SQL OPEN Query Sample

SQLSQL ServerCC++C# 
阅读更多 
select * from emp.dbo.users where status='A' and empType = 'PeopleSoft' and empid not in (
select empid from OPENQUERY(Linked_SERVER_NAME, 'SELECT empid FROM CorporateDir C , Location_Info L where C.status="A" and C.empType="PeopleSoft" and C.locationID=L.location and L.country="USA";'));


查看LINKED_SERVER_NAMME:

SQLSERVER  企业管理器 ---> 控制台 ---> SQL Server group
          ---> Database--->Security--->Linked Servers.


分享到：
| Log4j Email Appender Configuration Based ...
评论
发表评论

您还没有登录,请您登录后再发表评论

相关推荐

    New NHibernate + Sample Source Part2

    New NHibernate + Sample Source Part2 NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database. ...

    New NHibernate + Sample Source Part1

    New NHibernate + Sample Source Part1 NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database. ...

    NHibernate 2.0.1 + Movies + Sample Source Part2

    NHibernate-2.0.1 + Movies + Sample Source Part2 NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational ...

    Sql for mysql

    CHAPTER 2 The Tennis Club Sample Database . . . . . . . . . . . . . . . . 29 2.1 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 2.2 Description of the ...

    微软内部资料-SQL性能优化2

    Before we look at how SQL Server uses and manages its memory, we need to ensure a full understanding of the more common memory related terms. The following definitions will help you understand how SQL...

    ora分析脚本

    - sessions: currently open sessions - stack <os_pid> get process stack using oradebug - cursors [all] <match_str>: [all] parsed cursors - sharing <sql_id>: print why cursors are not shared - ...

    NBEARLISY使用

    Sample strong type query with sub queries: DataSet ds = db.Select(Northwind.Products) .Where(Northwind.Products.CategoryID.In ( db.Select(Northwind.Categories, Northwind.Categories.CategoryID)....

    VB编程资源大全（英文源码 数据库）

    <END><br>48,MyTool.zip An SQL Query tool for SQL Server or Oracle. <END><br>49,fab15.zip Complete Database Address book With Lots Of New Facilites.....下载 Now. <END><br>50,DataBaseViewer.zip...

    SAP屠夫作品汇总

    7.1.4 Sample Operating Concerns 492 7.1.5 Define profitability Segment Char. 493 7.1.6 Set Operating Concern 493 7.2 Master Data 493 7.2.1 Maintain Characteristic Values 493 7.2.2 Define ...

    Using Perl For Web Programming.pdf

    Processing QUERY_STRING into Useful Chunks H Using Regular Expressions tr/// and s/// H Printing the Page H Creating a Script on Your Web Server H Calling a CGI Script Directly H Limiting Data-...

Magicbox
Global site tag (gtag.js) - Google Analytics