我正在運(yùn)行data.bat文件,其中包含以下行:Rem Tis batch file will populate tablescd\program files\Microsoft SQL Server\MSSQLosql -U sa -P Password -d MyBusiness -i c:\data.sqldata.sql文件的內(nèi)容是: insert Customers (CustomerID, CompanyName, Phone) Values('101','Southwinds','19126602729')還有8個(gè)類似的行用于添加記錄。當(dāng)我跑這跟start> run> cmd> c:\data.bat,我收到此錯(cuò)誤信息:1>2>3>4>5>....<1 row affected>Msg 8152, Level 16, State 4, Server SP1001, Line 1string or binary data would be truncated.<1 row affected><1 row affected><1 row affected><1 row affected><1 row affected><1 row affected>此外,我顯然是一個(gè)新手,但是做什么Level #,并且state #意味著什么,我如何查找錯(cuò)誤消息,如上面的那個(gè):8152?
- 3 回答
- 0 關(guān)注
- 922 瀏覽