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 / goutham
update <table name>
set column = '0' + ph no:
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is raid, and how it can influence database performance?
What are different types of collation sensitivity?
What is the difference between inner join and equi join?
List the types of recovery model available in sql server?
Where are sql server usernames and passwords stored in the sql server?
How do I get to sql server configuration manager?
What is the difference between resultset and resultsetmetadata?
What is a sql join?
what is the difference between a primary key and a unique key? : Sql server database administration
How many types of triggers in sql server?
What is the difference between system objects and user objects?
What happens if null values are involved in datetime operations?
Can we take the full database backup in log shipping?
what is database replicaion? : Sql server database administration