问题很常见,让我们从代码可读性、灵活性和性能的角度来看看OpenEdge中每一个问题的优缺点。静态查询:+ performance: higher (supposedly, need commentspredicate-expression much,
even IF function is not recommended (can affect performa
我们有一个连接到Progress OpenEdge数据库的链接服务器安装程序的SQL Server数据库安装程序。我们使用类似于下面的代码创建了一些OpenEdge表的SQL Server视图(用于与SSRS一起使用):
将视图帐户创建为SELECT * FROM OPENQUERY(myLinkedServerNameCREATE VIEW clients AS SELECT * FROM OPENQUERY(myLinkedServerName,'SELECT * FROM PUB.clie