欧美一级特黄大片做受成人-亚洲成人一区二区电影-激情熟女一区二区三区-日韩专区欧美专区国产专区

怎樣從生產(chǎn)數(shù)據(jù)庫(kù)中獲得想要的查詢語(yǔ)句,把結(jié)果集批量插入到磁盤(pán)txt文件中

第一步:建立存儲(chǔ)過(guò)程

成都創(chuàng)新互聯(lián)是一家專業(yè)提供瓊結(jié)企業(yè)網(wǎng)站建設(shè),專注與成都做網(wǎng)站、網(wǎng)站建設(shè)、html5、小程序制作等業(yè)務(wù)。10年已為瓊結(jié)眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專業(yè)網(wǎng)站設(shè)計(jì)公司優(yōu)惠進(jìn)行中。

      實(shí)現(xiàn)傳入?yún)?shù),生成結(jié)果到磁盤(pán)的txt文件中;

USE [XXXXX]

GO

/****** Object:  StoredProcedure [dbo].[Proc_sql_to_file]    Script Date: 2018/5/13 15:47:10 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:<Author,,Name>

-- Create date: <Create Date,,>

-- Description:<Description,華為廠商為了獲取本系統(tǒng)數(shù)據(jù)寫(xiě)此存儲(chǔ)過(guò)程,調(diào)用此過(guò)程生成txt文件保存到服務(wù)器,然后ftp到華為,>

-- =============================================

ALTER PROCEDURE [dbo].[Proc_sql_to_file](

@servername varchar(50),--服務(wù)器名

@username varchar(50),--用戶名,如果用NT驗(yàn)證方式,則為空''

@password varchar(50) ,--密碼

@sql_query varchar(2000) , --SQL查詢語(yǔ)句,有字符條件時(shí)用單引號(hào)

@filePath_name varchar(1000), --導(dǎo)出路徑和文件名

@date datetime --保存文件時(shí)的生成日期戳

)AS

DECLARE @sql varchar(8000)

SET @sql='bcp "'+@sql_query + '" queryout '+' "'+@filePath_name+'_'+

convert(varchar(10),@date,21)+'.txt " /t "," /w'

+' /S '+@servername

+CASE WHEN ISNULL(@username,'')='' THEN '' ELSE ' /U '+@username END

+' /P '+ISNULL(@password,'')

select @sql

EXEC master..xp_cmdshell @sql

IF @@Error<>0 BEGIN

print '生成文件時(shí)出錯(cuò)了,請(qǐng)查看!'+@@Error

END

第二步:數(shù)據(jù)庫(kù)中新建任務(wù)計(jì)劃;

use XXXXX;---數(shù)據(jù)庫(kù)名稱

go

if exists(select 1 from sysobjects where name='temp11')

drop table temp11;

if exists(select 1 from sysobjects where name='temp12')

drop table temp12;

go

go

declare @date1 datetime;set @date1 =CONVERT(varchar(10),Getdate(), 21);

--華為采購(gòu)數(shù)量時(shí)間為當(dāng)天;

select CONVERT(varchar(100), GETDATE(), 102)+'入庫(kù)串碼' 手機(jī)串碼,'數(shù)量' 數(shù)量,'倉(cāng)庫(kù)' 倉(cāng)庫(kù) into temp11

union all

select 

'   '+t4.FSERIALNO,convert(varchar,1) Fqty,tl.fname FstockName

from T_STK_INSTOCK  t1

inner join T_STK_INSTOCKentry t2 on t1.fid=t2.fid

inner join  T_STK_INSTOCKENTRY_F t3 on t2.fid=t3.fid

left join T_STK_INSTOCKSERIAL t4 on t3.FENTRYID=t4.FENTRYID

inner join t_bd_material_l t6 on t2.FMATERIALID=t6.FMATERIALID and t6.FLOCALEID=2052

left join T_BD_STOCK_L tl on t2.FSTOCKID=tl.FSTOCKID and tl.FLOCALEID=2052

inner join ( select distinct m.FMATERIALID,m.FCATEGORYID,w.fname from T_BD_MATERIALBASE m

 join T_BD_MATERIALCATEGORY_L w on m.FCATEGORYID=w.FCATEGORYID

  ) u on t6.FMATERIALID=u.FMATERIALID

where u.fname like '%手機(jī)%'  and t6.fname like '%華為%'

and convert(varchar(10),t1.FDATE,21)=convert(varchar(10),getdate(),21)

--庫(kù)存數(shù)量

select CONVERT(varchar(100), GETDATE(), 102)+'在庫(kù)串碼' 手機(jī)串碼,'數(shù)量' 數(shù)量,'倉(cāng)庫(kù)' 倉(cāng)庫(kù) into temp12

union all

SELECT   FNUMBER,convert(varchar,1) Fqty,ckl.FNAME FstockName  

 FROM (select FNUMBER,FSERIALID,FMATERIALID from V_BD_OVERASERIALVIEW where FSERIALID>1 and  FDOCUMENTSTATUS = 'C' AND FFORBIDSTATUS = 'A') t0 

  INNER   JOIN (select FSERIALID from V_BD_OVERASERIALVIEW_L where FSERIALID>1  AND FLocaleId = 2052) t0_L ON (t0.FSERIALID = t0_L.FSERIALID)

  INNER    JOIN (select FSERIALID From V_BD_OVERASERIALORGVIEW where FSERIALID>1  and  FSTOCKSTATUS = 1 ) uu on uu.FSERIALID=t0.FSERIALID

  inner   join (select FMATERIALID,FNAME FSPMC From t_bd_material_l where FMATERIALID>1 and FLocaleId = 2052) tll on t0.FMATERIALID =tll.FMATERIALID 

  INNER   join (select FCATEGORYID,FMATERIALID From T_BD_MATERIALBASE where FCATEGORYID>1 and FCATEGORYID ='2092334' ) m on t0.FMATERIALID=m.FMATERIALID

  left   join (SELECT FSERIALID,MIN(FINPUTDATE) FINPUTDATE  FROM (select a.FSERIALID FSERIALID,case when b.FINPUTDATE not like '' then b.FINPUTDATE else   a.FBILLDATE

end FINPUTDATE from (select FSERIALID,FBILLDATE  From T_BD_SERIALBILLTRACE_e where FSERIALID>1 ) a  INNER   join (select FSERIALID,FINPUTDATE From T_BD_SERIALMASTEROTHER where FSERIALID>1) b on a.FSERIALID=b.FSERIALID ) a GROUP BY FSERIALID) b on t0.fserialid=b.FSERIALID

INNER   JOIN (select FSERIALID,FBILLTRACEID,FINVID from T_BD_SERIALBILLTRACE  where FBILLTRACEID>1 and FSERIALID>1 ) t5 ON T0.FSERIALID  = t5.FSERIALID  AND t5.FBILLTRACEID = (SELECT top 1 EE.FBILLTRACEID AS FBILLTRACEID FROM T_BD_SERIALBILLTRACE  EE WHERE T0.FSERIALID = EE.FSERIALID and( FINVID is not null and FINVID <> '' ) order by FBILLTRACEID desc)

 inner   join (select fid,FSTOCKID,FSTOCKSTATUSID from T_STK_INVENTORY where   FSTOCKSTATUSID=10000 and FOBJECTTYPEID= 'STK_Inventory'  and FKEEPERTYPEID='BD_KeeperOrg'and FOWNERTYPEID='BD_OwnerOrg' and FISEFFECTIVED=1 and FBASEQTY<>0) inv on inv.fid=t5.FINVID 

 inner   join (select FSTOCKID,FNAME from T_BD_STOCK_L where FSTOCKID>1 and FLocaleId = 2052   ) ckl on inv.FSTOCKID=ckl.FSTOCKID 

 where FSPMC like '%華為%'

option(maxdop 0)

 EXEC XXXXX..Proc_sql_to_file 'DESKTOP-89KSR2K','sa','dingweitao','select * from XXXXX.dbo.temp11','d:\k3cloud_Instock\k3cloud_Instock',@date1

  EXEC XXXXX..Proc_sql_to_file 'DESKTOP-89KSR2K','sa','dingweitao','select * from XXXXX.dbo.temp12','d:\k3cloud_Inventory\k3cloud_Inventory',@date1

go

drop table temp11,temp12

go

最終每天會(huì)更新數(shù)據(jù)到文件中;

分享文章:怎樣從生產(chǎn)數(shù)據(jù)庫(kù)中獲得想要的查詢語(yǔ)句,把結(jié)果集批量插入到磁盤(pán)txt文件中
本文地址:http://aaarwkj.com/article0/jeseoo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供營(yíng)銷(xiāo)型網(wǎng)站建設(shè)、關(guān)鍵詞優(yōu)化、網(wǎng)站營(yíng)銷(xiāo)響應(yīng)式網(wǎng)站、App設(shè)計(jì)動(dòng)態(tài)網(wǎng)站

廣告

聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請(qǐng)盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如需處理請(qǐng)聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來(lái)源: 創(chuàng)新互聯(lián)

h5響應(yīng)式網(wǎng)站建設(shè)
国产传媒在线播放一区| 天堂av一区二区三区| 哪里可以看黄色片日韩| 国产高清亚洲一区亚洲二区| 成人性生活黄色三级视频| 日韩成人大片在线播放| 日韩黄色精品中文视频| 日本美女激情在线观看| 五月婷婷六月丁香综合激情| 我的农村中年激情熟妇| 国产原创剧情av网址| 麻豆深夜激情在线观看| 未满十八禁在线观看免费| 丰满人妻被黑人猛烈进入免费| 亚洲成人久久久av一区| 狠狠综爱五月天的婷婷| 日本韩国黄色三级三级| 久久av少妇亚洲精品| 麻豆国产自拍在线视频| 四虎在线经典视频播放| 天天精品国产av九九久久久| 欧美日韩国产一区二区三区在线观看 | 欧美国内日本一区二区| 亚洲国产视频中文字幕| 国内传媒视频免费观看| 日本中文有码视频在线观看| 日本中文字幕免费专区| 久久精品国产精品亚洲片| 亚洲精品人妻av在线| 日韩中文字幕在线首页| 91国语对白在线观看| 麻豆乱淫一区二区三爱免费| 久久精人妻一区二区三区| 欧美高清一区二区在线播放| 自拍偷拍亚洲精品偷一| 国产精品神马午夜福利| 99久久精品免费国产一区| 日本欧美一区二区二区视频免费| 欧美激情另类综合国内| 2021最新四虎永久免费| 亚洲精品一级二级三级|