我对sqlserver有疑问，我的疑问是 [英] I have a doubt in sqlserver my doubt is

问题描述

如何打印下面的姓氏



1.首字母将是大写字母，剩下的字母在我的表名中会很小



2.如何使用小写字母打印所需的小写字母，并使用sqlserver

解决方案

AFAIK，内置任何内容SQL这样做：striung处理不是它的强项。



虽然你可以做到，（这涉及资本化每个字：http://stackoverflow.com/questions/5164201/ is-there-any-sql-server-in-function-to-convert-in-camel-case [ ^ ]并且它不会难以完全修改你的要求）。

这将是一个很好的在SQL中努力并且可能完全是错误的地方 - 这是一个数据输入和/或表示转换，并且可能最好在那时完成。而且更简单了！

查看链接，它将帮助您在sql server中创建存储过程



http://vaidymohan.com/2012/05/27/t-sql-function-for-proper-case-format/



http：// www .wisesoft.co.uk /脚本/ tsql_proper_case_udf.aspx

how to print employeenames like below

1. first letter will be capital and remaining letters will be small in my table names

2. how to print required letters in lower case and remaining in uppercase by using sqlserver

解决方案

AFAIK, there is nothing built in to SQL to do this: striung handling is not it's forte.

While you can do it, (this deals with Capitalising Each Word: http://stackoverflow.com/questions/5164201/is-there-any-sql-server-built-in-function-to-convert-string-in-camel-case[^] and it wouldn;t be hard to modify to exactly your requirement).
It would be a lot of effort in SQL and probably exactly the wrong place to do it - this is a data-entry and / or presentation conversion, and would probably be best done at that time. And a whole lot easier as well!

see the link, it will help you to create a stored procedure in sql server

http://vaidymohan.com/2012/05/27/t-sql-function-for-proper-case-format/

http://www.wisesoft.co.uk/scripts/tsql_proper_case_udf.aspx

这篇关于我对sqlserver有疑问，我的疑问是的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！