每天都能免费收到值得分享的好文 代码解析：CHARINDEX找到"-"的位置，SUBSTRING按位置截取。比如"张三-138..."，CHARINDEX返回3（第3个字符是"-"），名字就是1-2位（张三），电话从第4位开始。比Excel数据分列更灵活，不用预设固定分隔符位数！ 代码解析：REVERSE把路径 ...

Extracting categories from product codes, getting domains from email addresses, concatenating multiple values for labels—string processing is a daily occurrence. First, it is recommended to organize ...

Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI SQL joins are a fundamental feature for combining data from multiple tables based on ...

The About Us page of your website is an essential source of information for anyone who wants to know more about your business. It is where you showcase your history, the unique value of your work, ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...