ALTER PROCEDURE [dbo].[sp]
	-- Add the parameters for the stored procedure here
--@Id as int,
@TableToInsert sysname,	-- required table name to insert values into it 
@IdField varchar(50),	-- primary 

@UserId as numeric(18,0),
@ContactName as varchar(100),
@CategoryId as int,
@Name as varchar(100),
@Address as varchar(200),
@City as varchar(50),
@State as varchar(50),
@Zip as varchar(10),
@Phone as varchar(20),
@Email as varchar(100),
@PicSub as varchar(50),
@Description as varchar(255)

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

	Declare @InsertQuery as nvarchar(2000)
	Declare @PickNewId as nvarchar(500)
	Declare @NewID as numeric(18,0)

	set @PickNewId = 'Select ISNULL(MAX('+ @IdField +'),0) + 1 from '+ @TableToInsert +''
	--EXEC sp_executesql @PickNewId, N'@NewID int OUTPUT', @NewID OUTPUT

	--Return if column is already identity
	IF (COLUMNPROPERTY( OBJECT_ID(@TableToInsert),@IdField,'IsIdentity') = 1)
	BEGIN
		exec('SET IDENTITY_INSERT ' + @TableToInsert + ' ON')
	END

	
    -- Insert statements for procedure here
	SET @InsertQuery = N'INSERT INTO ' + @TableToInsert +
           N'(['+ @IdField +']'+
		   N',[ContactName] ,[CategoryId] ,[Name] ,[Address] ,[City] ,[State]'+
           N',[ZipCode] ,[Phone] ,[Email] ,[PicSub] ,[Description] ,[UserId])'+
     N'VALUES (exec(@PickNewId)'+
		   N',''+@ContactName+'' ,''+@CategoryId+'' ,''+@Name+'' ,''+@Address+'' ,''+@City+'''+
           N',''+@State+'' ,''+@Zip+'' ,''+@Phone+'' ,''+@Email+'' ,''+@PicSub+'' ,''+@Description+'''+
		   N',''+@UserId+'')'
    
	exec (@InsertQuery)
	IF (COLUMNPROPERTY( OBJECT_ID(@TableToInsert),@IdField,'IsIdentity') = 1)
	BEGIN
		exec('SET IDENTITY_INSERT ' + @TableToInsert + ' OFF')
	END
           select IDENT_CURRENT(@TableToInsert); 
END

	' + QUOTENAME(@PicSub, '''') + ',
	' + QUOTENAME(@Description, '''') + ',
	' + QUOTENAME(@UserId, '''' + '
	)'

' + QUOTENAME(@UserId, '''')+''