Interested to Buy Any Domain ? << Click Here >> for more details...
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...
- 7 Answers
- 11800 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Please illustrate physical database architecture? : SQL Server Architecture
What are diverse clauses that form a part of sql?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
what is the difference between delete table and truncate table commands? : Sql server database administration
what type of index will get created after executing the above statement? : Sql server database administration
How do I create an extended event in sql server?
When would you use the stored procedures or functions?
What is field with example?
How do I port a number to sql server?
What is a benefit of using an after insert trigger over using a before insert trigger?
Can we add an identity column to decimal datatype?
What are different types of roles provided by ssrs?
Some queries related to SQL
What is the difference between stored procedure and user defined functions?
