字符串类型系统函数 

 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

 

posted @ 2017-04-18 21:19  Devoloper_Jack  阅读(153)  评论(0)    收藏  举报