在单个查询中检索不同数据库的记录 [英] retrieve records of the different databases in a single query

问题描述

大家好，

我无法在单个查询中检索不同数据库的记录，而是使用以下代码:

Hi all,

I can''t retrieve records of the different databases in a single query, I use the following code:

OpenDatabase1()
OpenDatabase2()
Command.Connection = ConDB
Command.CommandType = CommandType.Text
Command.CommandText = "SELECT d1.Name,d2.Medium FROM Database1.Table1 AS d1, Database2.Table2 AS d2 WHERE d1.ID = d2.ID"
ObjDtReader = Command.ExecuteReader
  If ObjDtReader.Read = True Then
    Var1 = ObjDtReader("Name")
    Var2 = ObjDtReader("Medium")
End If
ObjDtReader.Close()
ConDB.Close()</pre>

如何获得这些记录?谢谢b4

how to get those records? thanks b4

推荐答案

您忘了写架构名称"dbo"

you forgot to write schema name ''dbo''

SELECT d1.Name,d2.Medium 
FROM Database1.dbo.Table1 AS d1, 
     Database2.dbo.Table2 AS d2 
WHERE d1.ID = d2.ID

祝您编码愉快！
:)

Happy Coding!
:)

使用存储的Proc并从c#调用存储的proc.

Use a stored Proc and call stored proc from c#.

这篇关于在单个查询中检索不同数据库的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！