数据类型

数字。

SELECT 123456789123456789123456789123456789 AS result
go

result
123456789123456789123456789123456789

(1 rows affected)

SELECT CAST(8.123456789 AS REAL)
go

result
8.123457

(1 rows affected)

SELECT CAST(8.123456789123456789 AS FLOAT)
go

result
8.1234567891234573

(1 rows affected)

文本。

SELECT '苹果' AS result
go

result
??

(1 rows affected)

SELECT N'苹果' AS result
go

result
苹果

(1 rows affected)