本文介绍了在sql server中组合列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧! 问题描述 Hi Frnds, 如何组合列。我在注册表中有FirstName,MiddleName,LastName。我使用此查询 选择FirstName +''''+ MiddleName +来自RegistrationTable的''''+ LastName ... 这里中间名也是空的。在那个时候选择查询显示空值,如果名字和姓也存在。那时我使用了ISNULL(MiddleName,''''),但是当时在FirstName和LastName之间不应该显示两个空格。解决方案 Hi Frnds, How to combine columns.I have FirstName,MiddleName,LastName in Registration Form.I Used this Query select FirstName+'' ''+MiddleName+'' ''+LastName from RegistrationTable ... Here Middle Name is Null Also.At that time Select Query showing null value if First and Last Name Present Also.At that time i used ISNULL(MiddleName,''''),but at that time two spaces should not show in between FirstName and LastName. 解决方案 这篇关于在sql server中组合列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!
10-13 01:53