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
- 19031 Views
- I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
SELECT Left(upper(<field_name>) , 1) + lower(substring
(<field_name>,2,len(<field_name>))) AS SomeName
FROM <table_name>
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do I view a trc file?
What is difference in performance between insert top (n) into table and using top with insert?
Comment,Datatypes are unlimited
Explain the disadvantages/limitation of the cursor?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is a domain constraint give an example?
Define left outer join in sql server joins?
How to convert a numeric expression from one data type to another?
Why is normalisation important?
Why do we use non clustered index?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Tell me about the approaches which you used to counter the DI problems.
What is attribute? : sql server analysis services, ssas
How do database indexes work?
How to get a list of all tables with "sys.tables" view in ms sql server?
