Don't forget to use Ltrim in SQL Server

xiaoxiao2021-03-06  78

when convert int to string using function str (), sql server could fill the whitespace at left when the integer's length is too short.so you can not using comparison operator just like 'like' convenient.The conclusion is when you want convert a Integer to string, Don't Forgot Using Ltrim Function to Clear The Whitespace.

转载请注明原文地址:https://www.9cbs.com/read-93916.html

New Post(0)