cp_insert.sql

来自「vbsql做的销售管理课程设计样本不完全仅为范例」· SQL 代码 · 共 16 行

USE cpxs
GO
IF EXISTS(SELECT name FROM sysobjects 
WHERE xtype= 'P' AND name ='cp_insert')
DROP PROCEDURE cp_insert
GO
CREATE PROCEDURE cp_insert
(@cpbh char(6),@cpmc char(12),@jg float,@kcl int)
AS
BEGIN
INSERT INTO cp VALUES(@cpbh,@cpmc,@jg,@kcl)
END
RETURN