如何在该表上执行合并sql表和archinvg数据 [英] how to execute combine sql table and archinvg data on that table

问题描述

你好，

我有一张像客户"这样的表，有10条记录.我想存档5条记录.
最后，我想执行该表，例如从客户中选择*"，那么它将显示10条记录(5条记录在customer中，5条记录在arching位置).
是否可以获取所有记录?.

你能帮我吗?
在此先感谢

Hello,

I have one table like ''customer'' with have 10 records. i want to archive in 5 records.
Finally i want to execute that table like ''select * from customer, then it will display 10 records(5 records are in customer and 5 records are in arching location).
is it possible to get all records..?

can you please help me.
thanks in advance

推荐答案

v3-基于注释

您将需要沿着
的联合查询

v3 - based on comment

You will need to a union query along the lings of

Select fields from Customer

UNION

Select line from
 Dbo.uftReadfileAsTable('MyPath','MyFileName')

参见
uftReadFileAsTable.txt [ http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/ [

See
uftReadFileAsTable.txt[^]

http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/[^] for more details

这篇关于如何在该表上执行合并sql表和archinvg数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！