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
- 11496 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
How do I find the default sql server instance?
Explain can you implement data mining in ssrs?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
How to view existing indexes on an given table using sp_help?
How except clause is differs from not in clause?
What is a database table?
Explain timestamp datatype?
What is the difference between the application object and session object?
What are the different types of data sources in ssrs?
What is collation sensitivity?
When we should use @@error?
What is the purpose of update statistics and scope_identity() function?
What is row_number () and partition by in sql server?
Why de-normalization required?
Explain Geometry datatype in sql server 2008 with example
