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 / 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 |
Post New Answer View All Answers
What is awe?
Explain what is the purpose of sql profiler in sql server?
Explain table valued parameters in sql server? Why tvp used?
What is implicit cursors?
What is a data source or ds? : sql server analysis services, ssas
What are user-defined functions (udfs) in sql server?
Can you explain full-text query in sql server?
Are null values the same as that of zero or a blank space?
what are isolation levels? : Sql server database administration
What is database isolation in sql server? : sql server database administration
What are the types of indexing?
Explain stored procedure?
What is cte (common table expression)?
How are the exceptions handled in sql server programming?
what data regions are and what are the different data regions?