> > >

Microsoft SQL Server MCQs

Which query will be used for a particular column of a table, if 'Reading' is to be replaced by 'Writing'?

Update [Table Name] set [Field Name]= (replace('Reading','Writing'))

Update [Table Name] set [Field Name]= (replace('Writing',' Reading'))

Update [Table Name] set [Field Name]= (replace([Field Name],' Writing'))

Update [Table Name] set [Field Name]= (replace([Field Name],' Reading '))

Update [Table Name] set [Field Name]= (replace([Field Name],'Reading','Writing'))

Update [Table Name] set [Field Name]= (replace([Field Name],'Writing ','Reading'))

Answer

Correct Answer: Update [Table Name] set [Field Name]= (replace([Field Name],'Reading','Writing'))

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it