插入数据报错String or binary data would be truncated

Question

创建的表如下~~~
CREATE TABLE [dbo].[News_Info](
[ID] [varchar](150) NOT NULL,
[Title] [varchar](150) NOT NULL,
[Text] [varchar](max) NOT NULL,
[Time] [datetime] NOT NULL,
[Rank] [varchar](10) NOT NULL,
 CONSTRAINT [PK_News_Info] PRIMARY KEY CLUSTERED 
(
[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
当我往里面插入数据的时候，无论插入什么数据都会报错说System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.
问题是哪里啊？问什么啊？

Answer 1

有字段长度不够 title id rank 检查一下

Answer 2

CREATE TABLE [dbo].[News_Info](
    [ID] [varchar](150) NOT NULL,
    [Title] [varchar](150) NOT NULL,
    [Text] [varchar](max) NOT NULL,
    [Time] [datetime] NOT NULL,
    [Rank] [varchar](10) NOT NULL,
 CONSTRAINT [PK_News_Info] PRIMARY KEY CLUSTERED 
(
    [ID] 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
insert into news_info select '1','asdffg','jkgkhgjkh','2010-010-25','iuhhhu'
select * from News_Info
go
drop table News_Info
/*
ID                                                                                                                                                     Title                                                                                                                                                  Text                                                                                                                                                                                                                                                             Time                    Rank
------------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- ----------
1                                                                                                                                                      asdffg                                                                                                                                                 jkgkhgjkh                                                                                                                                                                                                                                                        2010-10-25 00:00:00.000 iuhhhu(1 行受影响)
*/