xss_insert.sql

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

USE cpxs
GO
IF EXISTS(SELECT name FROM sysobjects 
WHERE xtype= 'P' AND name ='xss_insert')
DROP PROCEDURE xss_insert
GO
CREATE PROCEDURE xss_insert
(@xsbh char(6),@xsmc char(12),@dq char(10),@fzr char(8),@dh char(12),@mz text)
AS
BEGIN
INSERT INTO xss VALUES(@xsbh,@xsmc,@dq,@fzr,@dh,@mz)
END
RETURN