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
- 12058 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
Explain about the command-line tool SQLCMD?
What is the significance of master, tempdb and model databases?
What is executereader?
What is openxml in sql server?
What is self contained scalar sub query?
how to create “alternate row colour”?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
how you can get the list of largest tables in a database? : Sql server administration
What is store procedure? How do they work?
What is user defined datatypes and when you should go for them?
How to select an exiting database using mssql_select_db()?
How do I debug a stored procedure in sql server?
What is the difference between a primary key and a unique key? Are they the same?
What is a benefit of using an after insert trigger over using a before insert trigger?
Other than truncate statement, which other command can by-pass the trigger on the tables?
