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 / rajshekar
update <tablename>
set phno=cast (0 as datatype(1))+phno
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to count duplicated values in a column in ms sql server?
Why use identity in sql server?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Do you know what is sql injection?
Where cross join is used?
What is 'Join' and explain its various types.
What is sql stored procedure?
Can binary strings be converted into numeric or float data types?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is the difference between left and right outer join?
Can we call stored procedure in view in sql server?
What is the difference between grant and with grant while giving permissions to the user?
What is difference between getdate and sysdatetime in sql server 2008?
How do I run a trace in sql server?
What is user defined stored procedures?