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
- 11833 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / a
update <table_name> set phno = Convert(int, '0' +
Convert(varchar(10),phno))
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is the default fill factor value?
How do I find the sql server version?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
Define union, union all, minus, intersect?
define and explain the differences between clustered and non-clustered indexes.
What does the on update no action do?
What are the different types of collation sensitivity in sql server?
What are the disadvantages of using querystrings to send data from one page to another?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are the tools available in market as an alternative to sql server reporting services?
What is spid in sql server profiler?
List the different index configurations possible for a table?
Indexes are updated automatically is the full-text index also updated automatically?
what is a correlated sub-query? : Sql server database administration
