sql 例证

sql 例子

建表:(多主键,默认值)CREATE TABLE CSM_OTH_VipBabyInfo(   CompanyID   VARCHAR (20),   NewVipID    VARCHAR (20),   OldVipID    VARCHAR (20),   ModifyDTM   DATETIME DEFAULT getdate () NOT NULL,   CONSTRAINT pk PRIMARY KEY (CompanyID, NewVipID, OldVipID))带输入输出的存储过程的执行示例:declare @RetVal intexec spCSM_ChangeVipCard 'hk','a','b','c',@RetVal outputselect @RetVal