我得那个字段的长度是3000，
我的那个字段的内容是select convert(varchar(10),a.fld_secudate,21) fld_secudate, s.fld_Stock_code,s.fld_stock_Name,a.fld_openprice,a.fld_highprice,a.fld_lowprice,a.fld_newprice,a.fld_risefallrate,a.fld_secuamount,a.fld_secumoney, e.fld_securate,e.fld_currstock,r.fld_stkprofit,a.fld_updatedate fld_content_update from db_base.dbo.STOCK_CODE_TAB s join db_valueadd.dbo.SECU_WEEK a on (a.fld_stock_code=s.fld_stock_code and a.fld_type=s.fld_stock_type and a.fld_et=2) join db_valueadd.dbo.SECU_WEEK_EXTEND e on(e.fld_stock_code=s.fld_stock_code and e.fld_type=s.fld_stock_type and a.fld_secudate=e.fld_secudate) join db_valueAdd.dbo.ADD_STK_REPORT r on(r.fld_stock_code=s.fld_stock_code and r.fld_type=s.fld_stock_type) join (select w.fld_stock_code fld_stock_code,w.fld_type fld_type,w.fld_secudate fld_secudate,max(d.fld_Account_Date) fld_Account_Date from db_valueadd.dbo.SECU_WEEK w,db_valueAdd.dbo.ADD_STK_REPORT d where (w.fld_et=1 and substring(convert(varchar(10),d.fld_Account_Date,21),6,5) in('12-31','06-30') and w.fld_stock_code=d.fld_stock_code and d.fld_type=w.fld_type and w.fld_secudate>d.fld_Account_Date and (w.fld_updatedate>@startTime and w.fld_updatedate<=@endTime) ) group by w.fld_stock_code,w.fld_type,w.fld_secudate ) as tmptbl on(tmptbl.fld_type=r.fld_type and tmptbl.fld_Stock_Code=r.fld_Stock_Code and tmptbl.fld_Account_Date=r.fld_Account_Date) where (a.fld_updatedate>@startTime and a.fld_updatedate<=@endTime)现在不能粘贴了
我的那个字段的内容是select convert(varchar(10),a.fld_secudate,21) fld_secudate, s.fld_Stock_code,s.fld_stock_Name,a.fld_openprice,a.fld_highprice,a.fld_lowprice,a.fld_newprice,a.fld_risefallrate,a.fld_secuamount,a.fld_secumoney, e.fld_securate,e.fld_currstock,r.fld_stkprofit,a.fld_updatedate fld_content_update from db_base.dbo.STOCK_CODE_TAB s join db_valueadd.dbo.SECU_WEEK a on (a.fld_stock_code=s.fld_stock_code and a.fld_type=s.fld_stock_type and a.fld_et=2) join db_valueadd.dbo.SECU_WEEK_EXTEND e on(e.fld_stock_code=s.fld_stock_code and e.fld_type=s.fld_stock_type and a.fld_secudate=e.fld_secudate) join db_valueAdd.dbo.ADD_STK_REPORT r on(r.fld_stock_code=s.fld_stock_code and r.fld_type=s.fld_stock_type) join (select w.fld_stock_code fld_stock_code,w.fld_type fld_type,w.fld_secudate fld_secudate,max(d.fld_Account_Date) fld_Account_Date from db_valueadd.dbo.SECU_WEEK w,db_valueAdd.dbo.ADD_STK_REPORT d where (w.fld_et=1 and substring(convert(varchar(10),d.fld_Account_Date,21),6,5) in('12-31','06-30') and w.fld_stock_code=d.fld_stock_code and d.fld_type=w.fld_type and w.fld_secudate>d.fld_Account_Date and (w.fld_updatedate>@startTime and w.fld_updatedate<=@endTime) ) group by w.fld_stock_code,w.fld_type,w.fld_secudate ) as tmptbl on(tmptbl.fld_type=r.fld_type and tmptbl.fld_Stock_Code=r.fld_Stock_Code and tmptbl.fld_Account_Date=r.fld_Account_Date) where (a.fld_updatedate>@startTime and a.fld_updatedate<=@endTime)现在不能粘贴了
投诉microsoft