locked
how to make a mapping(not view but not physical copy).thank u very much RRS feed

  • Question

  • hi

       may i ask, is it possible to  make a mapping(not view but not physical copy),maybe something like a snapshot in oracle

    thank u very much in advance for your kindness help

    best regards

    martin

    Wednesday, October 16, 2013 10:53 AM

Answers

All replies

  • Hi,

    Is this what you mean?  http://technet.microsoft.com/en-us/library/ms175158.aspx

    If not, please elaborate.



    Thanks, Andrew
    My blog...

    Wednesday, October 16, 2013 10:55 AM
  • hi Andrew:

       thank u very much for ur reply

      i dont think so.since for this,it shouldmake a snapshot for the whole database

      what would i like to do,for example,in databaseA,make a snapshot( like oracle )of tableB of databseB  ,i dont know whether it is posible for sql server

      thank u very much again for ur kindness help

    best regards

    martin

    Wednesday, October 16, 2013 10:59 AM
  • I think you are looking for indexed view here. Why are you thinking view is not an option for you.

    Please elaborate.


    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

    Wednesday, October 16, 2013 11:01 AM
    Answerer
  • In Oracle, a snapshot is a table that contains the results of a query of one or more tables or views...

    In SQL Server, you can do this via SELECT..INTO..FROM.

    For more info please see this link:

    Inserting Rows by Using SELECT INTO


    Saeid Hasani, sqldevelop.wordpress.com

    Download Books Online for SQL Server 2012

    • Marked as answer by martinwang1985 Wednesday, October 16, 2013 2:30 PM
    Wednesday, October 16, 2013 11:10 AM
  • hi  Saeid Hasani

       thank u very much for your kindness help

    best regards

    martin

     

    Wednesday, October 16, 2013 2:34 PM