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
- 12059 Views
- Value Labs, I also Faced
- E-Mail Answers
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 sql server english query?
How to connect of datebase with sql express.?
What is normalization? Explain its different types?
How can I tell if sql server is 32 or 64 bit?
What happens to a trigger with multiple affected rows?
What is the process of normalising?
what is spatial nonclustered index
What is updatable resultset?
how you can get the list of largest tables in a database? : Sql server administration
Explain what is cte (common table expression)?
Do you know the isolation level that sql server support?
How can I check that whether automatic statistic update is enabled or not?
What are window functions in sql server?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How you provide security to cube? : sql server analysis services, ssas
