查询数据库行 [英] Querying database rows

问题描述

请帮我提供一个代码示例，我可以用它为数据库中表中的每个数据行生成多个查询

katumba Martin
Thanx

please help me with a code sample i can use to generate multiple queries for each of the data rows in my table in a database

katumba Martin
Thanx

推荐答案

多个查询是什么意思?您是说要多次选择每一行吗?如何使用union关键字两次选择数据?

What do you mean by multiple queries ? Do you mean you want to select each row more than once ? How about using the union keyword to select the data twice ?

检查一下，这是您的要求

Hi,


Check it, This is your requirement

Select * from 
(select 'A' As  TableName, object_id, name from sys.columns -- Your Row1 Or Query1
 union 
 select 'B' As TableName, object_id, name from sys.tables -- Your Row2 Or Query2
 ) As A
left join sys.indexes B  on A.Object_id = B.Object_Id

快乐编码

Happy Coding

这篇关于查询数据库行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！