Stuff is a Sql server function.It Deletes a specified
length of characters and inserts another set of characters
at a specified starting point.
SELECT STUFF('abcdef', 2, 3, 'ijklmn')
::will return te following result::
aijklmnef
2)materialized
A materialized view is a database object that contains the results of a query. They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots.A materialized view can query tables, views, and other materialized views. Collectively these are called master tables (a replication term) or detail tables (a data warehouse term).
Above answer was rated as good by the following members:
jabir.mkk, kperumal75
