alter proc AddMenu @ID int, @Place_ID int, @Title nvarchar(200),@DllName nvarchar(100),@FormPath nvarchar(200),@Parameter nvarchar(200), @Priority int, @IconName nvarchar(400), @MaxFormCount int, @Place_ID_Web int, @IconFont nvarchar(200), @IconColor nvarchar(200), @Url nvarchar(2000), @Dom_ID_RowType int as begin if not exists(select id from Places where ID = @ID) begin insert into Places (ID,Place_ID,Title,DllName,FormPath,Parameter,Pririty,IconName,MaxFormCount,Place_ID_Web,IconFont,IconColor,Url,Dom_ID_RowType) values (@ID,@Place_ID,@Title,@DllName,@FormPath,@Parameter,@Priority,@IconName,@MaxFormCount,@Place_ID_Web,@IconFont,@IconColor,@Url,@Dom_ID_RowType) end else begin update Places set Place_ID = @Place_ID, Title=@Title, DllName=@DllName, FormPath =@FormPath, Parameter= @Parameter, Pririty=@Priority, IconName=@IconName, MaxFormCount=@MaxFormCount, Place_ID_Web= @Place_ID_Web, IconFont=@IconFont, IconColor=@IconColor, Url=@Url, Dom_ID_RowType = @Dom_ID_RowType where ID = @ID end end