ALTER PROCEDURE dbo.compute_pci
@ro_na varchar(50),@ym char(7),@lufu char(2)
AS
set nocount on --这句加上
declare @Sarea decimal(18,3)--路宽
declare @S_zh_k int
declare @S_zh_m int--起始桩号
declare @E_zh_k int
declare @E_zh_m int--中止桩号
select @Sarea = lane*lan_width,
@S_zh_k = Szh_k,
@S_zh_m = Szh_m,
@E_zh_k = Ezh_k,
@E_zh_m =Ezh_m
from design where road_name = @ro_na
@ro_na varchar(50),@ym char(7),@lufu char(2)
AS
set nocount on --这句加上
declare @Sarea decimal(18,3)--路宽
declare @S_zh_k int
declare @S_zh_m int--起始桩号
declare @E_zh_k int
declare @E_zh_m int--中止桩号
select @Sarea = lane*lan_width,
@S_zh_k = Szh_k,
@S_zh_m = Szh_m,
@E_zh_k = Ezh_k,
@E_zh_m =Ezh_m
from design where road_name = @ro_na
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货