字符串类型系统函数

 1 /*
 2 SmallInt  是在 2 个字节来存放的整数。 最大值为 32,767。 最小值为 -32,767。 
 3 */
 4 
 5 --select smallint
 6 
 7 select datalength('retetrte') 字符串长度
 8 
 9 select * from systypes where name like '%int%' order by name
10 
11 select * from systypes where name like '%da%' order by name
12 
13 select * from systypes where name like '%var%' order by name
14 
15 select * from systypes where name like '%text%' order by name
16 
17 select d1.length,name from systypes d1 where name like '%int%' order by length
18 
19 select d1.length,name,* from systypes d1 where name like '%int%' order by d1.name