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...
Answers were Sorted based on User's Feedback
Answer / anand k
Hi,
Yoy didn't mention the datatype of the column "phone
number"
prob the varchar datatype has used to the phno.
update <tablename>
set phno = cast(0 as varchar(1)) + phno
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / rajshekar
update <tablename>
set phno=cast (0 as datatype(1))+phno
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / khalid moin
update <tablename>
set <column name>='0'||<coulmn name>;
this query will update the values present in column with
prefix 'o'
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / a
update <table_name> set phno = Convert(int, '0' +
Convert(varchar(10),phno))
Is This Answer Correct ? | 1 Yes | 3 No |
Diffrent types of function
Explain what is lock escalation?
How do I edit a procedure in sql server?
Please explain go command in sql server?
write the query for taking database restore in sql?
What are acid properties of transaction?
What's the maximum size of a row?
How to use “drop” keyword in sql server and give an example?
What are the different types of queries?
What is database white box testing?
how to control the amount of free space in your index pages? : Sql server database administration
Can we create clustered index on composite key?