Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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...

Question Posted / durga prasad

Answers were Sorted based on User's Feedback



I have a table in which phno is one of the columns.i do have some values in tht phno column.i need ..

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

Is This Answer Correct ?    16 Yes 1 No

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need ..

Answer / durgaprasad

Thank you very much Mr.Anand

Is This Answer Correct ?    0 Yes 1 No

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need ..

Answer / rajshekar

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

Is This Answer Correct ?    0 Yes 1 No

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need ..

Answer / khalid moin

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

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

Is This Answer Correct ?    0 Yes 1 No

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need ..

Answer / mechinenirao

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

Is This Answer Correct ?    2 Yes 4 No

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need ..

Answer / a

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

Is This Answer Correct ?    1 Yes 3 No

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need ..

Answer / goutham

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

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More SQL Server Interview Questions

Explain the advantages of merge replication?

0 Answers  

What protocol does sql server use?

0 Answers  

How can you ensure that the database and sql server based application perform well?

0 Answers  

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

How self join is different from outer join?

0 Answers   Blue Star,

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

What is the diffrence between update_one and auto_fix?

3 Answers   IBM,

How to connect a database with sql express.?

0 Answers   MCN Solutions,

what is the system function to get current user's user id? : Sql server database administration

0 Answers  

What is the difference between login and a user?

13 Answers   CTS, TCS,

How to get the query of a table in sql server?

0 Answers  

What is ACID Property of Transaction?

10 Answers  

For more SQL Server Interview Questions Click Here
Categories