任何人都可以在sqlserver中解释这些查询用法 [英] can anybody explain these query usage in sqlserver

问题描述

select len(cast(left('026-100' 3) as int))

快速回复此查询结果

reply this query result fast

推荐答案

这意味着首先从左边获取3个''026-100''的字符，即026并将其转换为整数。所以它变成26并且它的len得到它的长度所以结果是2



顺便提一下你的查询不正确必须有冒号 ''026-100''和3之间的逗号

It means first get 3 char of ''026-100'' from left which is 026 and cast it as integer. so it becomes 26 and its len gets it length so th result is 2

By the way your query is incorrect there must be a colon comma between ''026-100'' and 3

这篇关于任何人都可以在sqlserver中解释这些查询用法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！