我这样声明,系统说不对。@nMouldID int (4)
下面是原码
(
@nMouldID int (4),
@vCampaignCode nvarchar (10),
@vCampTitle nvarchar (200),
@vCampDesc nvarchar (1000),
@vBrand nvarchar (1),
@dCampBeginDate datetime,
@dCampEndDate datetime,
@vCampImgURL nvarchar(200),
@vStutus nvarchar(1),
@vCreated nvarchar(50),
@vUpdated nvarchar(50)
)
AS
SET NOCOUNT ON
Insert INTO TblCampaign (nMouldId,vCampaignCode,vCampTitle,vCampDesc,vBrand,dCampBeginDate,dCampEndDate,vCampImgURL,vStutus,vCreated,vUpdated)
Values
(@nMouldID,@vCampaignCode,@vCampTitle,@vCampDesc,@vBrand,@dCampBeginDate,@dCampEndDate,@vCampImgURL,@vStutus,@vCreated,@vUpdated)
RETURN
下面是原码
(
@nMouldID int (4),
@vCampaignCode nvarchar (10),
@vCampTitle nvarchar (200),
@vCampDesc nvarchar (1000),
@vBrand nvarchar (1),
@dCampBeginDate datetime,
@dCampEndDate datetime,
@vCampImgURL nvarchar(200),
@vStutus nvarchar(1),
@vCreated nvarchar(50),
@vUpdated nvarchar(50)
)
AS
SET NOCOUNT ON
Insert INTO TblCampaign (nMouldId,vCampaignCode,vCampTitle,vCampDesc,vBrand,dCampBeginDate,dCampEndDate,vCampImgURL,vStutus,vCreated,vUpdated)
Values
(@nMouldID,@vCampaignCode,@vCampTitle,@vCampDesc,@vBrand,@dCampBeginDate,@dCampEndDate,@vCampImgURL,@vStutus,@vCreated,@vUpdated)
RETURN
它默认是8
@nMouldID int,即可
bigint、int、smallint 和 tinyint 数据类型存储
语句中vCampaignCode无效,是怎么回事?
declare @nMouldID int 即可
bigint 是 8
smallint 2
tinyint 1