CREATE PROCEDURE Int_Web_Site(
@AClass bit,--添加类别
@GetID int,--获取ID,更新
@WebName nvarchar(50)--更新内容
)
AS
if @AClass = 0 BEGIN
INSERT [Web_Site](WebName) VALUES(@WebName)
endif @AClass = 1 BEGIN
UPDATE [Web_Site] Set WebName =+@WebName where id=+@GetID
end
GO
@AClass bit,--添加类别
@GetID int,--获取ID,更新
@WebName nvarchar(50)--更新内容
)
AS
if @AClass = 0 BEGIN
INSERT [Web_Site](WebName) VALUES(@WebName)
endif @AClass = 1 BEGIN
UPDATE [Web_Site] Set WebName =+@WebName where id=+@GetID
end
GO
CREATE PROCEDURE Int_Web_Site(
@AClass bit,--添加类别
@GetID int,--获取ID,更新
@WebName nvarchar(50)--更新内容
)
AS
if @AClass = 0 BEGIN
INSERT [Web_Site](WebName) VALUES(@WebName)
endif @AClass = 1 BEGIN
UPDATE [Web_Site] Set WebName =@WebName where id=@GetID --不要用‘+ +’
endGO
@AClass bit,--添加类别
@GetID int,--获取ID,更新
@WebName nvarchar(50)--更新内容
)
AS
if @AClass = 0 BEGIN
INSERT [Web_Site](WebName) VALUES(@WebName)
endif @AClass = 1 BEGIN
UPDATE [Web_Site] Set WebName=@WebName where id=@GetID
endGO
这样就行了