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
- 11851 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happens if you delete a table that is used by a view?
What is nolock hint in sql server 2008
How do I delete a sql server database?
What are indexes in ms sql server?
Why use “nolock” in sql server?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How do users use Report Builder with SQL Server data sources?
How to connect of datebase with sql express.?
What is snapshot report?
What is PROJECTION Operation?
Which joins are sql server default?
Explain about service Broker functions?
What is difference between joins and subqueries?
What is multilevel indexing?
Do you know how to send email from database?
