我正在运行data.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
data.sql文件的内容是:
insert Customers
(CustomerID, CompanyName, Phone)
Values('101','Southwinds','19126602729')
还有8个类似的行用于添加记录。
当我跑这跟start> run> cmd> c:\data.bat,我收到此错误信息:
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?
相关分类