求简单存储过程？

2011-05-23 04:32:32 110 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

中兴FTTR光猫变简易OLT：低成本搭建全光监控与局域网实战指南本文详细介绍了如何将中兴FTTR光猫改造为简易OLT设备，实现低成本全光监控与局域网扩展。通过LOID认证、桥接模式设置及终端数破解，用户可利用二手设备搭建高性能光纤网络，适用于远程监控和长距离组网场景，显著降低部署成本。阅读详情

CREATE TABLE [dbo].[t_user](
[vID] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_t_user_vID] DEFAULT (''),
[vName] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_t_user_vName] DEFAULT (''),
[vGrade] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_t_user_vGrade] DEFAULT (''),
[dBrithday] [smalldatetime] NOT NULL,
[bSex] [bit] NOT NULL CONSTRAINT [DF_t_user_bSex] DEFAULT ((0)),
[vReMark] [nvarchar](max) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF_t_user_iSum] DEFAULT ((0))
) ON [PRIMARY]

CREATE TABLE [dbo].[t_details](
[iAutoID] [int] IDENTITY(1,1) NOT NULL,
[vID] [varchar](20) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_t_details_vID] DEFAULT (''),
[vChinese] [float] NULL CONSTRAINT [DF_t_details_vChinese] DEFAULT ((0)),
[vMaths] [float] NULL CONSTRAINT [DF_t_details_vMaths] DEFAULT ((0)),
[vEnglish] [float] NULL CONSTRAINT [DF_t_details_vEnglish] DEFAULT ((0)),
CONSTRAINT [PK_t_details] PRIMARY KEY CLUSTERED
(
[iAutoID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

alter PROCEDURE Updat_tb @Is_Insert int,
@vID varchar(20),
@vName2 varchar(20),
@vGrade varchar(10),
@Dbrithday varchar(20) ,
@bSex bit,
@dChinese float,
@dMaths float,
@dEnglish float,
@vRemark varchar(200)
as
if @Is_Insert =1
begin
INSERT INTO [t_user]([vID],[vName],[vGrade],[dBrithday],[bSex],[vReMark])
VALUES(@vID,@vName2,@vGrade,@Dbrithday,@bSex,@vRemark)
INSERT INTO [t_details]([vID],[vChinese],[vMaths],[vEnglish])
VALUES(@vID, @dChinese,@dMaths,@dEnglish)
end
Else
Delete [t_user] where [vID] =@vID
Delete [t_details] where [vID] =@vID
INSERT INTO [t_user]([vID],[vName],[vGrade],[dBrithday],[bSex],[vReMark])
VALUES(@vID,@vName2,@vGrade,@Dbrithday,@bSex,@vRemark)
INSERT INTO [t_details]([vID],[vChinese],[vMaths],[vEnglish])
VALUES(@vID, @dChinese,@dMaths,@dEnglish)

我执行 exec Updat_tb 1,'aaa','b','mm','02/23/2011',1,80,90.5,70,'aaaaa'
为什么在[t_details]表中会插入两条相同的记录..
应该在[t_details]表中只会插入一条记录..

...全文