IF EXISTS(SELECT NAME FROM sysobjects s WHERE s.name='AddMenu') DROP proc AddMenu GO create proc AddMenu @ID int, @Place_ID int, @Title nvarchar(200),@DllName nvarchar(100),@FormPath nvarchar(200),@Parameter nvarchar(200) as begin insert into Places (ID,Place_ID,Title,DllName,FormPath,Parameter) values (@ID,@Place_ID,@Title,@DllName,@FormPath,@Parameter) end