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

Answer Posted / durgaprasad

Thank you very much Mr.Anand

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are connections to sql server encrypted?

570


Explain sql delete command?

601


Give me any three differences between Truncate and Delete.

561


Do you know what are the ways available in sql server to execute sql statements?

537


Do you know how to make remote connection in database?

549






How to connect ms access to sql servers through odbc?

541


If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

667


Where do you find the default Index fill factor and how to change it?

597


What is user-defined inline table-valued function?

512


What is 2nf normalization?

535


Relational calculus is what type of language?

573


How to check status of stored procedure in sql server?

441


What is Sqlpaging in SqlServer 2005 ?

656


What is a partitioned view?

564


What is star, snowflake and star flake schema? : sql server analysis services, ssas

649