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 is the difference between cartesian product and cross join?

0 Answers  

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

What is Inner Join?

2 Answers  

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,

What is sql server transaction log file?

0 Answers  

What are built in functions?

0 Answers  

What is difference in performance between insert top (n) into table and using top with insert?

0 Answers  

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

Describe and explain about SQL native client?

0 Answers  

What Is Rdbms?

0 Answers   Accenture,

What is master database? : SQL Server Architecture

0 Answers  

What is Schema? and why we use schemas?

4 Answers