Server and Table Alias

Question

Server and Table Alias

Matthew24

SSCommitted

Points: 1736
More actions
August 20, 2009 at 4:37 pm

#225162

Hi Guys,
Can any one point me in the right direction please.
I have a long statement that involves trasnsferring some data to a remote database.
I have lots of statements:
insert into table1 select *.table1 from server.database.dbo.table1 where etc etc
What I want to do is create a variable or alias for the "server.database.dbo." element so that I can define this at the start of the statement and use it for different source data.
Is this possible, and if so how to do it ?
Many thanks,
Matt

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

in 2005, you can use a synonym for any object...a table/view/procedure, etc, but not part of a name.

in 2000, i think you'd have to use a view for any object on your linked server, and that should work for your updates/inserts etc.

but again, it'd be a view per object, and not just the first three parts of the 4 part name;

maye someone else has a better idea.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Steve Jones - SSC Editor SSC Guru Points: 736222 More actions · Answer 2

I'd second Lowell's advice here. Don't really know of a better way.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

that's how I do it all the time. I even have some procedures to automate it.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]