how to select a field with firstletter as capital and
remaining are small letters
Answer Posted / velmurugan
Select UPper(Left(Company,1)) + Lower(Right(Company,Len
(Company)-1)) From Company
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is named calculation? : sql server analysis services, ssas
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
ow to bring suspect mode datbase online from scratch
How to insert data into an existing table?
What is difference between rownum and rowid?
System variable and temporary variables
How many types of keys are there?
What are the dmvs?
What is a system database and what is a user database?
What is a schema in ms sql server 2005?
what exactly sql injuction.how to overcome.....
Detail about query optimizer?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How to set database to be read_only in ms sql server?
Do you know what are different types of replication in sql server?