CREATE PROCEDURE sp_RegionUpdate
@RegionDescription NCHAR(50),
@RegionID int output
AS
DECLARE @Count int
-- 查找是否有相同名称的记录
SELECT @Count = Count(RegionID) FROM Region WHERE
RegionDescription = @RegionDescription
IF @Count = 0
INSERT INTO Region
(RegionDescription) values
(@RegionDescription)
SET @RegionID = @@IDENTITY
Return 1
GO
请问一下GO附近哪有语法错误
@RegionDescription NCHAR(50),
@RegionID int output
AS
DECLARE @Count int
-- 查找是否有相同名称的记录
SELECT @Count = Count(RegionID) FROM Region WHERE
RegionDescription = @RegionDescription
IF @Count = 0
INSERT INTO Region
(RegionDescription) values
(@RegionDescription)
SET @RegionID = @@IDENTITY
Return 1
GO
请问一下GO附近哪有语法错误
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货