Rajeswari_R
Valued Member
Points: 66
More actions
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
Steve Jones - SSC Editor
SSC Guru
Points: 728159
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.
Follow me on Twitter: http://www.twitter.com/way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply