sql怎么创建存储过程的问题
来源:百度知道 编辑:UC知道 时间:2024/05/12 05:54:47
靠代码创建即可:给你个代码参考:详细有不会的可以联系QQ37191520,一起讨论
--drop procedure up_et03a
CREATE PROCEDURE [up_et03a]
AS
declare @s_wtpt varchar(4) -- server TEAHS432A write point
declare @s_rdpt varchar(4) -- server TEAHS432A read point
declare @s_biswtpt varchar(4) -- server TEAHS432A write point
declare @s_bisrdpt varchar(4) -- server TEAHS432A read point
declare @l_wtpt31 varchar(4) -- local TEAHS432A write point
declare @l_rdpt31 varchar(4) -- local TEAHS432A read point
declare @line CHAR(3)
declare @event CHAR(3)
declare @partcode CHAR(2)
declare @engno CHAR(9)
declare @passdate CHAR(10)
declare @passtime CHAR(8)
declare @readpt CHAR(4)
declare @writept CHAR(4)
declare @palletno CHAR(8)
declare @shift CHAR(1)
declare @serialno VARCHAR(7)
declare @worker VARCHAR(20)
begin
select @l_rdpt31 = readpt,@