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

Answer / durgaprasad

Thank you very much Mr.Anand

Answer / rajshekar

update <tablename>
set phno=cast (0 as datatype(1))+phno

Answer / khalid moin

update <tablename>
set <column name>='0'||<coulmn name>;

this query will update the values present in column with
prefix 'o'

Answer / mechinenirao

update <tablename>
set Phno = '0' + phno

Answer / a

update <table_name> set phno = Convert(int, '0' +
Convert(varchar(10),phno))

Answer / goutham

update <table name>
set column = '0' + ph no:

How to create and drop temp table in sql server?

0 Answers  

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

what is create database syntax? : Sql server database administration

0 Answers  

Write an sql query for deleting duplicate rows?

0 Answers  

How many columns can exist together per table?

0 Answers   Cap Gemini,

What is the difference between for xml raw and for xml auto?

0 Answers  

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

2 Answers   IBM,

What is amo? : sql server analysis services, ssas

0 Answers  

Can a rule be bound to any column of any data type?

0 Answers  

How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  

How would you add a section to a table?

0 Answers  

What do you understand by the analysis services in sql server?

0 Answers