Post reply

Synonym for Qualified name specification of Table([LinkedName].[databasename].[username].[tablename])

  • January 23, 2004 at 1:49 am

    #84363

    I have procedures which fetches data and doing manipulation from one SQL Server to other using linked server. I have to select the data from both the database i need to specify the qualified name for the table name. Is there synonym like in Oracle

  • January 23, 2004 at 10:20 am

    #491423

    Not completely sure what you mean, but you can create a view

    create view myview as select * from servera.ownerb.tablec

     

    and then select from this view.

     

  • January 28, 2004 at 12:58 am

    #491888

    My table data contains mass data(over GB), so i am not using views and I need to specify the criteria to fetch the records

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply