奇怪的问题: SELECT TOP 1 ISNULL(PRICE,'''')
FROM [TABLE1]其中PRICE 是Money 类型的,并且表中PRICE 没有为NULL的值昨天这个还工作好好的,今天起来就Msg 235, Level 16, State 0, Line 1
Cannot convert a char value to money. The char value has incorrect syntax.
FROM [TABLE1]其中PRICE 是Money 类型的,并且表中PRICE 没有为NULL的值昨天这个还工作好好的,今天起来就Msg 235, Level 16, State 0, Line 1
Cannot convert a char value to money. The char value has incorrect syntax.
FROM [TABLE1]
FROM [TABLE1]SELECT TOP 1 ISNULL(LTRIM(PRICE),'')
FROM [TABLE1]
insert @t select 23SELECT TOP 1 ISNULL(PRICE,'')
FROM @t
/*
---------------------
23.00(1 行受影响)
*/
FROM [TABLE1]