我正在运行数据.bat文件包含以下行:
Rem Tis batch file will populate tables
cd\program files\Microsoft SQL Server\MSSQL
osql -U sa -P Password -d MyBusiness -i c:\data.sql
数据的内容.sql文件是:
insert Customers
(CustomerID, CompanyName, Phone)
Values('101','Southwinds','19126602729')
还有8行类似的行用于添加记录.
When I run this with start
> run
> cmd
> c:\data.bat
, I get this error message:
1>2>3>4>5>....<1 row affected>
Msg 8152, Level 16, State 4, Server SP1001, Line 1
string or binary data would be truncated.
<1 row affected>
<1 row affected>
<1 row affected>
<1 row affected>
<1 row affected>
<1 row affected>
当然,我是个新手,但是Level #
和state #
是什么意思,我如何查找上面的错误消息:8152?