Answer Posted / priyanka rani
By using Update statement. For example Update table_name set column_name='value' where column_name='your condition'
if required use where condition
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different acid properties?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are built in functions?
Explain what are magic tables in sql server?
How to find the second highest salary of an employee?
What are the advantages of user-defined functions over stored procedures in sql server?
How do you handle datasets larger than 50 gb?
What is store procedure? How do they work? When do you use?
How to write an inner join with the where clause in ms sql server?
which table keeps the locking information? : Sql server administration
What do you mean by table and field in sql?
How do I view a script in sql server?
How will you decide the active and passive nodes?
Do you know what is a trace frag? Where do we use it?