如何在sql表中合并旧数据和新数据 [英] how to merge old data and new data in sql table
问题描述
大家好,我对如何在sql中删除或复制表合并旧数据和新数据有疑问吗?我将如何做到这一点?您可以为此提供帮助或提供良好的链接资源吗?谢谢
例如:我在表中上传了数据,然后我更新了现有数据上的所有数据文件,但它希望再次上传相同的数据,但与上传的第一个数据相同,因为它已被更新,但不会同时更改我的数据库中的sql数据表源中也不会重复..其中使用新旧数据来体验现有数据正在更新但我可以使其合并到sql中的数据表中.所以请帮助我.
在此先感谢
hi everyone i have a question on how to merge old data and new data with dropping or duplicating table in sql? wherein how i will do that?? can you help me or give me a good link resource for this? thanks
for example: i have upload data in my table then i update all data file on the existing data yet it expect to upload again same data but same with the 1st data uploaded since it is already updated it will not change at the same time yet it will not also duplicated in the sql data table source in my database..wherein im experiencing the existing data with new and old data is updating BUT i can make it to merge it to the data table in sql..so please help me..
thanks in advance
推荐答案
MERGE
http://technet.microsoft.com/en-us/library/bb510625.aspx [ ^ ]
MERGE
http://technet.microsoft.com/en-us/library/bb510625.aspx[^]
这篇关于如何在sql表中合并旧数据和新数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!