Interested to Buy Any Domain ? << Click Here >> for more details...
how to select a field with firstletter as capital and
remaining are small letters
- 11 Answers
- 19374 Views
- I also Faced
- E-Mail Answers
Answer Posted / venakteswara rao
select upper(<colummn name>,1,1)+substring(lower(<column
name,2,len(<column name>))) as anyname from table name
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What are page splits? : SQL Server Architecture
What is index fragmentation in ms sql server?
What is a bit datatype?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is the difference between functions and stored procedures?
How to delete an existing database user?
What is the chart in report?
Explain indexes disadvantages?
Do you know what is lock escalation?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
what are triggers? : Sql server database administration
What is sql collation?
What is the default server name for sql server?
Explain trigger and trigger types?
