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:

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

Does server sql treat char as a variable-length or fixed-length column?

1 Answers  

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1 Answers  

Are null values the same as that of zero or a blank space?

1 Answers  

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

what is sql injection?

2 Answers  

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

Give main differences between "Truncate" and "Delete".

1 Answers   HCL,

What is a cube? : sql server analysis services, ssas

1 Answers  

What is triggers and its types?

1 Answers  

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1 Answers