CREATE PROCEDURE Insert_EstateAge @EstateAge nvarchar(64)
AS
IF EXISTS(SELECT EstateAgeID FROM EstateAge WHERE EstateAge = @EstateAge)
BEGIN
SELECT -1
RETURN
END
INSERT INTO EstateAge(EstateAge)
VALUES(@EstateAge)
SELECT @@IDENTITY
RETURN这是我写的存储过程,当插入 <1 或 2-3 这样的字符串就有问题了,怎么改啊?
AS
IF EXISTS(SELECT EstateAgeID FROM EstateAge WHERE EstateAge = @EstateAge)
BEGIN
SELECT -1
RETURN
END
INSERT INTO EstateAge(EstateAge)
VALUES(@EstateAge)
SELECT @@IDENTITY
RETURN这是我写的存储过程,当插入 <1 或 2-3 这样的字符串就有问题了,怎么改啊?
AS
Create Table #T(EstateAge int)
/*
将<1 或 2-3,或还有其它规则的转换一下插入到#T里
*/ IF EXISTS(SELECT EstateAgeID FROM EstateAge WHERE EstateAge In (Select EstateAge from #T))
BEGIN
SELECT -1
RETURN
END
INSERT INTO EstateAge(EstateAge)
Select EstateAge from #T
--VALUES(@EstateAge)
SELECT @@IDENTITY
RETURN