Mssql Equivalent Of Mysql "merge" Storage Engine

[dbnewbie]

Hi,

Mysql database provides a storage engine called "MERGE".A "MERGE" table is a collection of identical tables that can be used as one.(Identical meaning same column name,column width, column order etc.) .

The advantage is you can split a really huge table like LOG tables, STATS tables into seperate smaller tables but would still be able to make queries on them like a single table. More details, can be got from here:

http://dev.mysql.com/doc/refman/4.1/...ge-engine.html

My question is that do we have an equivalent of MYSQL "MERGE" in MSSQL ????

Thanks,

[rmiao]

You can use view or sp in mssql to get data from multiple tables.

[skhanal]

You can use Partitioned table in SQL 2005