sql
文章平均质量分 68
jieeeeeeeeeeee
这个作者很懒,什么都没留下…
展开
-
U8采购单价修复sql以及字段说明
iTaxPrice=1*ROUND(iquantity * ioritaxcost,2)-(ROUND(iquantity * ioritaxcost,2) * 100 / (100 + iTaxRate)),--本币税额。iUnitCost=1*ROUND(((ROUND(iquantity * ioritaxcost,2) * 100 / (100 + iTaxRate))/iQuantity),6)--本币无税单价。原创 2022-09-30 16:08:41 · 145 阅读 · 0 评论 -
U8全阶BOM展开sql
DECLARE @level INTSET @level= 1; WITH BomTree AS(SELECT bom.Version,c.ParentId AS TParentId,g.cinvcode as 母件编码,f.cinvcode AS 子件编码,f.bSelf,c.bomid,a.OpComponentId,a.ComponentId,b.wiptype,c.ParentId,0 AS LevelT ,bom.StatusFROM bom_bom bomLEFT JOIN b...原创 2022-03-17 09:57:02 · 2008 阅读 · 3 评论 -
sql一些常用的存储过程记录
----- 1. 查询所有存储过程select Pr_Name as [存储过程], [参数]=stuff((select ','+[Parameter]from (select Pr.Name as Pr_Name,parameter.name +' ' +Type.Name + ' ('+convert(varchar(32),parameter.max_length)+')' as Parameterfrom sys.procedures Pr left joinsys.para原创 2021-12-31 16:06:42 · 142 阅读 · 0 评论 -
sql XML转table
将查询出来的datatable 转XML 在传到sql里面转成sql里面的table declare @Xml xml Declare @sql Nvarchar(max) set @Xml='<root><columnList><columnItem columnName="sStyleCode"></columnItem><columnItem columnName="sColorName"></...原创 2021-12-31 15:58:31 · 805 阅读 · 0 评论