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
- 12068 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
Explain DBCC?
What are user-defined functions (udfs) in sql server?
What is optimization and its types?
where the connection string store in the database
What is difference between delete & truncate commands?
How to delete a database in ms sql server?
What stored by the msdb?
If user is owning any SQL Objects, can we drop that user
Write a sql query to sort on different column name according to the parameters passed in the function?
What are parameterized reports?
How can you fetch alternate records from a table?
When would you prefer to have a minimum number of indexes?
When would you use sql joins?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is the sql case statement used for?
