Sunday, 26 January 2014

Differentiate between: a.) TRANSLATE and REPLACE. b.) What is Merge Statement used for?

a.) TRANSLATE and REPLACE.

- Translate is used to substitute character by character.
- Replace is used to substitute a single character with a word.
 b.) What is Merge Statement used for?

- Merge statement is used to select rows from one or more data source to updating and insert into a table or a view.

0 comments:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More