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 many joins in sql server?
What is the difference between Normalization and De-normalization?
Do you know the isolation level that sql server support?
What is store procedure? When do you use?
what is the maximum size of a row? : Sql server database administration
Explain what is the difference between a local and a global temporary table?
What is the process of normalising?
What is the maximum rows in sql server table?
What is sql server programming?
What are the differences between lost updates and uncommitted dependencies?
Where can you find the error log information? : sql server database administration
Can you explain what is indexed view? How to create it?
How many types of objects are there?
How to create a simple stored procedure in ms sql server?
What is constraints and its types?