1.获取字段内容长度(判断值是否超出数据库长度限制)
select len('你好') as '值长度',DATALENGTH('你好') as '字节长度'
值长度 字节长度
2 4
2获取字段中指定内容出现次数
select LEN(string)-LEN(REPLACE(string,';','')) from sys_table
select len('你好') as '值长度',DATALENGTH('你好') as '字节长度'
值长度 字节长度
2 4
select LEN(string)-LEN(REPLACE(string,';','')) from sys_table