Synonyms 2

Question

Post reply

Synonyms 2

Steve Jones - SSC Editor

SSC Guru

Points: 738917
More actions
September 13, 2014 at 2:18 pm

#293172

Comments posted to this topic are about the item Synonyms 2

Viewing 15 posts - 1 through 15 (of 17 total)

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

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 1

This code

CREATE SYNONYM Emp

FOR Human.Resources.Employee

;

go

select

BusinessEntityID

, NationalIDNumber

, JobTitle

from Emp

;

will not work as there is no such thing as

Human.Resources.Employee

Try it out if you don't have the AWDB

CREATE SYNONYM FLEH

FOR sy.s.columns;

GO

SELECT

*

FROM FLEH;

DROP SYNONYM FLEH;

😎

Edit: There was a typo in the question, Steve fixed it straight away;-)

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

Thanks. Corrected.

That's what I get for typing the question instead of cut/paste

Hany Helmy SSChampion Points: 13921 More actions · Answer 3

Steve Jones - SSC Editor (9/13/2014)
Thanks. Corrected.
That's what I get for typing the question instead of cut/paste

So u should consider using cut/paste instead 😀

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

Eazy mozo 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 5

basic question.

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 6

Easy one to start the week, thanks. 🙂

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

An easy one to start the week to be sure, but it had me re-reading the question 3 times and looking at the code a couple of times because I didn't see the trick. It was almost too easy to not have a trick in there somewhere. Nonetheless, if you're not familiar with synonyms, it's a good learning opportunity. Sometimes the simple things teach the most because they reach the people without making them do a pile of work to get the point.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

SqlMel SSCrazy Points: 2901 More actions · Answer 8

SqlMel

SSCrazy

Points: 2901

September 15, 2014 at 6:23 am

#1745444

Easy one, Steve.

Thanks!

---------------
Mel. 😎

OCTom SSChampion Points: 11785 More actions · Answer 9

I know nothing about synonyms but I thought "what good would it be if you couldn't use it in a simple select?".

🙂

Tom

RLilj33 SSCrazy Points: 2203 More actions · Answer 10

Ed Wagner (9/15/2014)
An easy one to start the week to be sure, but it had me re-reading the question 3 times and looking at the code a couple of times because I didn't see the trick. It was almost too easy to not have a trick in there somewhere.

+1. Was thinking the same thing...

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 11

Thank you, Steve, good one.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

SQLRNNR SSC Guru Points: 281344 More actions · Answer 12

Everybody loves a good synonym now and then. It's more fun with a bad synonym though.

Thanks for the question Steve.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

timwell SSCertifiable Points: 5315 More actions · Answer 13

I got it wrong because he talked about 4-part naming and then only used a 2-part name.

It seems if he says he's "working in" the database, that mean he's connected (presumably in SSMS) so that the server and database are known?

Kick6Tiger SSCrazy Points: 2380 More actions · Answer 14

"A synonym is used to create a short name for an object, replacing the four part naming of an object with a shorter name."

Not entirely accurate as Four-part names for function base objects are not supported. Synonyms are restricted to using three part naming of functions. 🙂

Aigle de Guerre!