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

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

What can be used instead of trigger?

0 Answers   ADITI,

How to encrypt data between dialogs?

0 Answers  

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

Why variables called the most powerful component of ssis?

0 Answers  

Explain the use of containers in ssis and also their types?

0 Answers  

What are scalar functions?

0 Answers  

What is query optimizer in sql server?

0 Answers  

What is acid mean in sql server?

0 Answers  

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

How to invoke a trigger on demand?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories