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...
Answer Posted / goutham
update <table name>
set column = '0' + ph no:
Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
How to delete duplicate records based on single column from a table?
What is a performance monitor?
If no size is defined while creating the database, what size will the database have?
Why should we go for stored procedures? Why not direct queries?
What’s the use of custom fields in report?
What are “lost updates”?
Does index speed up select statements?
Explain how to maintain a fill factor in existing indexes?
What are entities and relationships?
Does the order of columns in update statements matter?
How will you decide the active and passive nodes?
SQL Server Architecture ?
Where do you find the default Index fill factor and how to change it?
How to convert binary strings into integers in ms sql server?
How to convert a unicode strings to non-unicode strings?