In SQL Server 2005, if the target type does not include zero in its value space, the cast fails and the result is the empty sequence.

• 在SQL Server 2005中,如果目标类型在其值空间内不包含零,则转换失败且结果为空序列。