从SQLserver获取所有数据库名称,并在所有数据库中获取表tblStudent的ID值 [英] get all Database name from SQLserver and get ID value form Table tblStudent in all of that Databases
问题描述
我有5个数据库,如SR_DB1,SR_DB2,SR_DB3,SR_DB4,SR_DB5
所有人都有相同的表:tblStudent(ID,Name,Sex)
我的问题是我想从所有数据库的tblStudent获取数据库名称和名称
我希望它显示如下
SR_DB1 Name = - Something
SR_DB2 Name = - Something
SR_DB3 Name = - Something
SR_DB4 Name = - Something
SR_DB5 Name = - Something
I Have 5 Database like SR_DB1,SR_DB2,SR_DB3,SR_DB4, SR_DB5
all of their Have the same table : tblStudent(ID,Name,Sex)
My Problem is i wanna get Databases Name , And Name from tblStudent of all Database
I want it display like this
SR_DB1 Name = --Something
SR_DB2 Name = --Something
SR_DB3 Name = --Something
SR_DB4 Name = --Something
SR_DB5 Name = --Something
推荐答案
SELECT Name FROM SR_DB1.dbo.tblStudent WHERE ID = somevalue
格式化您可以使用的输出在select查询中跟随而不是Name
to format your output you can use following in select query instead of Name
'SR_DB1 Name = ' + Name
重复选择查询其他四个数据库。
repeat select query for other four databases.
这篇关于从SQLserver获取所有数据库名称,并在所有数据库中获取表tblStudent的ID值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!