久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

  1. <small id='Ah4pH'></small><noframes id='Ah4pH'>

    <tfoot id='Ah4pH'></tfoot>
    <i id='Ah4pH'><tr id='Ah4pH'><dt id='Ah4pH'><q id='Ah4pH'><span id='Ah4pH'><b id='Ah4pH'><form id='Ah4pH'><ins id='Ah4pH'></ins><ul id='Ah4pH'></ul><sub id='Ah4pH'></sub></form><legend id='Ah4pH'></legend><bdo id='Ah4pH'><pre id='Ah4pH'><center id='Ah4pH'></center></pre></bdo></b><th id='Ah4pH'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='Ah4pH'><tfoot id='Ah4pH'></tfoot><dl id='Ah4pH'><fieldset id='Ah4pH'></fieldset></dl></div>
  2. <legend id='Ah4pH'><style id='Ah4pH'><dir id='Ah4pH'><q id='Ah4pH'></q></dir></style></legend>

      <bdo id='Ah4pH'></bdo><ul id='Ah4pH'></ul>

    1. SQL Server:導(dǎo)入和歸檔每周數(shù)據(jù)

      SQL Server: Importing and archiving weekly data(SQL Server:導(dǎo)入和歸檔每周數(shù)據(jù))
        <bdo id='3T0nc'></bdo><ul id='3T0nc'></ul>

        <tfoot id='3T0nc'></tfoot>
      • <legend id='3T0nc'><style id='3T0nc'><dir id='3T0nc'><q id='3T0nc'></q></dir></style></legend>

              <small id='3T0nc'></small><noframes id='3T0nc'>

                <tbody id='3T0nc'></tbody>

                <i id='3T0nc'><tr id='3T0nc'><dt id='3T0nc'><q id='3T0nc'><span id='3T0nc'><b id='3T0nc'><form id='3T0nc'><ins id='3T0nc'></ins><ul id='3T0nc'></ul><sub id='3T0nc'></sub></form><legend id='3T0nc'></legend><bdo id='3T0nc'><pre id='3T0nc'><center id='3T0nc'></center></pre></bdo></b><th id='3T0nc'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='3T0nc'><tfoot id='3T0nc'></tfoot><dl id='3T0nc'><fieldset id='3T0nc'></fieldset></dl></div>
                本文介紹了SQL Server:導(dǎo)入和歸檔每周數(shù)據(jù)的處理方法,對(duì)大家解決問(wèn)題具有一定的參考價(jià)值,需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)吧!

                問(wèn)題描述

                感謝任何想法/建議......

                我被要求想出一種簡(jiǎn)單的方法來(lái)導(dǎo)入我們從外部供應(yīng)商那里收到的新數(shù)據(jù)(文本文件).我們得到幾個(gè)文本文件,每個(gè)文件都需要導(dǎo)入到自己的表中.某些表必須將當(dāng)前/現(xiàn)有數(shù)據(jù)移動(dòng)到名為 TABLENAME_Previous 的表中(以處理各種現(xiàn)有報(bào)告),然后清空當(dāng)前表并將新數(shù)據(jù)導(dǎo)入其中.此外,現(xiàn)在上一個(gè)"表中的任何數(shù)據(jù)都必須附加到存檔表中.

                I've been asked to come up with a simple way to import new data we receive from an outside vendor (text files). We get several text files and each needs to be imported into its own table. Some tables have to have the current/existing data moved into a table called TABLENAME_Previous (to work with various existing reports), then have the current table emptied out and the new data imported into it. Also, any data now in the "previous" table has to be appended to an archive table.

                這是一個(gè)例子:

                customer.txt 來(lái)自供應(yīng)商....

                1. 首先我們將customers_previous的內(nèi)容移動(dòng)到customers_arch

                接下來(lái)我們將customers的內(nèi)容移動(dòng)到customers_previous

                Next we move the contents of customers to customers_previous

                最后我們將新的 customers.txt 文件導(dǎo)入表 customers

                Finally we import the new customers.txt file into the table customers

                有沒(méi)有人寫過(guò)一個(gè) SQL 例程來(lái)做到這一點(diǎn),或者知道在哪里可以找到一個(gè),修改起來(lái)不會(huì)太痛苦?

                Has anyone ever written a SQL routine to do this, or knows where to find one, that wouldn't be too painful to modify?

                謝謝

                推薦答案

                你可以嘗試這樣的事情:

                you may try something like this:

                將您以前的數(shù)據(jù)復(fù)制到存檔

                To copy your previous data to Archive

                Insert into customers_arch select * from customers_previous
                

                要將您的客戶數(shù)據(jù)復(fù)制到上一個(gè):

                To Copy your Customer Data to Previous:

                truncate table customers_previous;
                insert into customers_previous select * from customers
                

                然后要加載您的文本文件,請(qǐng)?jiān)谇宄笫褂门坎迦爰虞d您的客戶表.

                Then to Load you text file use Bulk Insert to load your customer table after clearing it.

                truncate table customers;
                bulk    insert customers
                from    'd:\yourfolder\customers.txt'
                WITH   
                      (  
                         FIELDTERMINATOR =',',  
                         ROWTERMINATOR ='\n'  
                      );
                

                更新:好的,Brian,回答你的另一個(gè)問(wèn)題,如何為保存在 WeeklyTable 中的多個(gè)文件運(yùn)行它.

                UPDATE: Ok, Brian, to answer your other question, How to run it for multiple files saved in your WeeklyTable.

                假設(shè)你的 WeeklyTable 是這樣的:

                Suppose your WeeklyTable is like this:

                Declare @WeeklyTable TABLE(ID int Identity(1,1), [FileName] varchar(50))
                insert into @WeeklyTable Values
                ('Customers'),('Orders'), ('Order_Details')
                

                您可以創(chuàng)建一個(gè)動(dòng)態(tài)查詢來(lái)為每個(gè)文件運(yùn)行您的腳本.

                You can create a dynamic query to run your script for each file.

                Declare @Template varchar(max)
                Set @Template = '
                    -- Start of [[FILENAME]] --------------------
                    Insert into [FILENAME]_arch select * from [FILENAME]_previous
                    GO
                
                    truncate table [FILENAME]_previous;
                    insert into [FILENAME]_previous select * from [FILENAME]
                    GO
                
                    truncate table [FILENAME];
                    bulk    insert [FILENAME]
                    from    ''d:\yourfolder\[FILENAME].txt''
                    WITH   
                          (  
                             FIELDTERMINATOR ='','',  
                             ROWTERMINATOR =''\n''  
                          );
                
                
                '
                Declare @s varchar(max)
                Declare @FileName varchar(50)
                Declare @ID int =0
                
                Select TOP 1 @ID=ID, @FileName=[FileName] From @WeeklyTable Where ID>@ID order by ID
                While @@ROWCOUNT>0 Begin
                    Set @s = REPLACE(@Template, '[FILENAME]', @FileName)
                    Print @s
                --  EXEC(@s)  -- Uncomment to EXEC the script.
                    Select TOP 1 @ID=ID, @FileName=[FileName] From @WeeklyTable Where ID>@ID order by ID
                End
                

                這篇關(guān)于SQL Server:導(dǎo)入和歸檔每周數(shù)據(jù)的文章就介紹到這了,希望我們推薦的答案對(duì)大家有所幫助,也希望大家多多支持html5模板網(wǎng)!

                【網(wǎng)站聲明】本站部分內(nèi)容來(lái)源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問(wèn)題,如果有圖片或者內(nèi)容侵犯了您的權(quán)益,請(qǐng)聯(lián)系我們刪除處理,感謝您的支持!

                相關(guān)文檔推薦

                Break down a table to pivot in columns (SQL,PYSPARK)(分解表以按列進(jìn)行透視(SQL、PYSPARK))
                Spark giving Null Pointer Exception while performing jdbc save(Spark在執(zhí)行jdbc保存時(shí)給出空指針異常)
                execute query on sqlserver using spark sql(使用 spark sql 在 sqlserver 上執(zhí)行查詢)
                How can I compare the one line in one CSV with all lines in another CSV file?(如何將一個(gè) CSV 中的一行與另一個(gè) CSV 文件中的所有行進(jìn)行比較?)
                How to map the column wise data in flowfile in NiFi?(如何在 NiFi 中映射流文件中的列數(shù)據(jù)?)
                connect SQL to apache nifi(將 SQL 連接到 apache nifi)
                  • <tfoot id='IYTrj'></tfoot>
                      <i id='IYTrj'><tr id='IYTrj'><dt id='IYTrj'><q id='IYTrj'><span id='IYTrj'><b id='IYTrj'><form id='IYTrj'><ins id='IYTrj'></ins><ul id='IYTrj'></ul><sub id='IYTrj'></sub></form><legend id='IYTrj'></legend><bdo id='IYTrj'><pre id='IYTrj'><center id='IYTrj'></center></pre></bdo></b><th id='IYTrj'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='IYTrj'><tfoot id='IYTrj'></tfoot><dl id='IYTrj'><fieldset id='IYTrj'></fieldset></dl></div>

                          <bdo id='IYTrj'></bdo><ul id='IYTrj'></ul>
                            <tbody id='IYTrj'></tbody>
                          <legend id='IYTrj'><style id='IYTrj'><dir id='IYTrj'><q id='IYTrj'></q></dir></style></legend>
                        • <small id='IYTrj'></small><noframes id='IYTrj'>

                        • 主站蜘蛛池模板: 天天爱天天操 | 欧美激情a∨在线视频播放 成人免费共享视频 | 免费一区二区 | 一区二区三区中文字幕 | a视频在线观看 | 久久精品久久精品久久精品 | 国产精品久久久久久久久久免费看 | 亚洲vs天堂 | 男女羞羞视频免费 | 成人伊人 | 日韩字幕一区 | 老司机狠狠爱 | 玖玖免费 | 国产精品视频一区二区三区不卡 | 色综合色综合色综合 | 操视频网站 | 亚洲精品v日韩精品 | 精品无码久久久久国产 | 亚洲最色视频 | 中文无吗 | 看av网址| 国产精品免费在线 | 91久久精品一区二区三区 | 精品国产乱码久久久久久1区2区 | 99精品国自产在线观看 | 久久久精品一区二区三区 | 国产资源网| 先锋影音资源网站 | 免费黄色成人 | 日韩国产一区二区三区 | 天堂va在线 | 99精品99 | 国产精品不卡 | 久久精品国产99国产精品 | 久久久国产一区二区三区 | 欧美又大粗又爽又黄大片视频 | 国产乱码精品1区2区3区 | 韩日免费视频 | 欧美成视频 | 国产在线h | 久久久久久av |