declare @s table(col nvarchar(10) COLLATE French_CS_AS) insert @s select N'ABC' SELECT * from @s where CAST('abc' AS nvarchar(5)) COLLATE French_CI_AS = colcol ---------- ABC(1 行受影响)SELECT * from @s where CAST('abc' AS nvarchar(5)) = col col ----------(0 行受影响)
declare @s varchar(10),@i int
set @s = 'AB'
select cast(@s as varbinary(3)),ascii('A'),ascii('B'),4*16 +1 as '0x41' 0x41
-------- ----------- ----------- -----------
0x4142 65 66 65(所影响的行数为 1 行)
1、MS SQL SERVER中时间的精度问题http://blog.csdn.net/HEROWANG/archive/2008/05/02/2361045.aspx
2、小数如何转换成时间
http://blog.csdn.net/HEROWANG/archive/2008/05/16/2451272.aspx希望对你有用
declare @s table(col nvarchar(10) COLLATE French_CS_AS)
insert @s select N'ABC'
SELECT *
from @s
where CAST('abc' AS nvarchar(5)) COLLATE French_CI_AS = colcol
----------
ABC(1 行受影响)SELECT *
from @s
where CAST('abc' AS nvarchar(5)) = col
col
----------(0 行受影响)