sqlserver插入数据,报执行存储过程错误,求大神科普

图片说明

你数据库的表时怎么创建的?

USE [lmweb]
GO

/****** Object: Table [dbo].[visitip] Script Date: 10/09/2015 21:32:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].visitip NOT NULL,
[ffromrefid] nvarchar NULL,
[ffromusername] nvarchar NULL,
[fip] nvarchar NULL,
[fpv] [int] NULL,
[fdate] [smalldatetime] NULL,
[ftimefirst] [datetime] NULL,
[ftimelast] [datetime] NULL,
[fisjsed] [bit] NULL,
[ptid] [int] NULL,
CONSTRAINT [PK_visitip] PRIMARY KEY CLUSTERED
(
[fid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'被访问的用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'visitip', @level2type=N'COLUMN',@level2name=N'ffromrefid'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'被访问的用户' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'visitip', @level2type=N'COLUMN',@level2name=N'ffromusername'
GO

ALTER TABLE [dbo].[visitip] ADD CONSTRAINT [DF_visitip_fpv] DEFAULT ((0)) FOR [fpv]
GO

ALTER TABLE [dbo].[visitip] ADD CONSTRAINT [DF_visitip_fischeck] DEFAULT ((0)) FOR [fisjsed]
GO

ALTER TABLE [dbo].[visitip] ADD CONSTRAINT [DF_visitip_ptid] DEFAULT ((0)) FOR [ptid]
GO

insert into 表名。错误提示很清晰,先比对一下数据类型和字段,存储过程不对劲

字段名和存储过程调出来看看呗!