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:

Give an example of SQL injection attack ?

0 Answers   HAL,

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

How many types of Cursor in SQL SERVER?

1 Answers  

Can we store videos inside the sql server table?

0 Answers  

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

How to make a remote connection in a database?

0 Answers  

How do I create a partition table in sql server?

0 Answers  

create index a on employee(dno) In this,which index was created?

2 Answers  

What is reference section?

0 Answers  

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

What are temporal tables in sql server 2016?

0 Answers  

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,