CREATE PROCEDURE Result AS set nocount on SELECT distinct d.订单行, h.合同量, d.处理级, d.物料号, convert(decimal(38,3),p.成材率) as 成材率, convert(decimal(38,3),0) as 计划量 into #t FROM dbo.DOR d INNER JOIN dbo.HTL h ON d.订单行=h.订单行 INNER JOIN dbo.PUCCL p ON d.物料号 = p.物料号 and d.钢种=p.钢种 ORDER BY d.订单行 desc ,d.处理级 DESCdeclare @订单行 char(14),@计划量 decimal(7,3)update #t set @计划量=case @订单行 when 订单行 then @计划量 else 合同量 end/成材率 ,计划量=@计划量,@订单行=订单行 select * from #tset nocount off GO
--自带数据库 NorthWind里的存储过程,简单,且是带参数的 CREATE PROCEDURE CustOrdersOrders @CustomerID nchar(5) AS SELECT OrderID, OrderDate, RequiredDate, ShippedDate FROM Orders WHERE CustomerID = @CustomerID ORDER BY OrderIDGO
联机帮助找“create procedure”,那一页有多个例子,分门别类的
AS
set nocount on
SELECT distinct d.订单行, h.合同量, d.处理级, d.物料号,
convert(decimal(38,3),p.成材率) as 成材率,
convert(decimal(38,3),0) as 计划量
into #t FROM dbo.DOR d
INNER JOIN dbo.HTL h ON d.订单行=h.订单行
INNER JOIN dbo.PUCCL p ON d.物料号 = p.物料号 and d.钢种=p.钢种
ORDER BY d.订单行 desc ,d.处理级 DESCdeclare @订单行 char(14),@计划量 decimal(7,3)update #t set @计划量=case @订单行 when 订单行 then @计划量 else 合同量 end/成材率
,计划量=@计划量,@订单行=订单行
select * from #tset nocount off
GO
当然多来CSDN也NO PROBLEM的了…………
CREATE PROCEDURE CustOrdersOrders @CustomerID nchar(5)
AS
SELECT OrderID,
OrderDate,
RequiredDate,
ShippedDate
FROM Orders
WHERE CustomerID = @CustomerID
ORDER BY OrderIDGO