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 triggers?

0 Answers  

mention different types of relationships in the dbms?

0 Answers  

What is replication with database mirroring? : sql server database administration

0 Answers  

What is the use of builtinadministrators group in sql server? : sql server security

0 Answers  

What are the operating modes in which database mirroring runs?

0 Answers  

What part does database design plays a role in performance of an sql server-based application?

0 Answers  

Why the trigger fires multiple times in single login?

0 Answers  

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

Does sql server use t sql?

0 Answers  

What are dml (data manipulation language) statements in ms sql server?

0 Answers  

What is nonclustered index with included columns ?

0 Answers  

What is SQL Server?

0 Answers   Atos Origin,

For more SQL Server Interview Questions Click Here
Categories