select SUBSTRING(crpdefine4, 1, CHARINDEX('-',crpdefine4)-1) 机台号,
SUBSTRING(crpdefine4, CHARINDEX('-', crpdefine4)+1, len(crpdefine4)-CHARINDEX('-', crpdefine4)) 盘号
from sfc_workreport
> Msg 537, Level 16, State 2, Server WIN-0G4ATSRCMDA, Procedure , Line 0
传递给 LEFT 或 SUBSTRING 函数的长度参数无效。
> [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]传递给 LEFT 或 SUBSTRING 函数的长度参数无效