sqlserver 查询oracle数据

最新推荐文章于 2024-08-06 14:51:02 发布

翘着二郎腿的程序猿

最新推荐文章于 2024-08-06 14:51:02 发布

阅读量719

点赞数

分类专栏： Oracle Sqlserver

本文链接：https://blog.csdn.net/qq_36248777/article/details/108283831

版权

Sqlserver 同时被 2 个专栏收录

18 篇文章 0 订阅

订阅专栏

Oracle

4 篇文章 0 订阅

订阅专栏

[proc_GetLisJianYan] '5465489646416'

alter PROCEDURE [dbo].[proc_GetLisJianYan]                  
@ZYID VARCHAR(200)
AS  BEGIN
SELECT * into #temp FROM openquery([LISORCL],'SELECT  * from VI_LISRESULTTOXK  where patientid =''123''ORDER  by checktime desc')

DECLARE @dss VARCHAR(200)= 'insert  into #temp SELECT TOP 100*  from openquery([LISORCL],'+'''SELECT  * from VI_LISRESULTTOXK  where patientid ='''+''''+@ZYID+''''+ '''ORDER  by checktime desc'''+')'

EXEC   (@dss)

SELECT*from #temp
 DROP  TABLE #temp
end