Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz...
- 7 Answers
- 11789 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / mechinenirao
update <tablename>
set Phno = '0' + phno
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is use of except clause? How does it differ from not in clause?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is query and its types?
Explain the steps needed to create a scheduled job?
What is the index requirement in SQL Azure?
What is stretch database in sql server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What are “phantom rows”?
What are parameterized reports? What are cascading parameters in ssrs reports?
Do you know query execution plan?
how to determine the service pack currently installed on sql server? : Sql server database administration
Is ssrs support other database except ms sql server?
What is the difference between locking and multi-versioning?
What is resource db in sql server?
What is a functions and types in sql server?
