10 October 2007 12:43 tonyrogerson

How to find a Mac address in SQL Server

select address1, address2, address3, post_code

from country c

       inner join address a on a.country_id = c.id

where c.country_name = 'Scotland'

 

:) - I know, terrible isn't it; I thought with the gloomy Autumn weather we now have, setting off in the dark etc... an oh no joke was the order of the day.

 

Anybody know any other IT related ones?

 

Tony

 

Filed under:

Comments

# re: How to find a Mac address in SQL Server

10 October 2007 14:18 by Matija Lah

How to change the owner of a procedure?

EXECUTE AS <owner>

SELL PROCEDURE <procedure name> TO <new owner>

You didn't say it has to be syntactically correct... ;)

ML

# re: How to find a Mac address in SQL Server

11 October 2007 08:45 by GrumpyOldDBA

very sad!

# re: How to find a Mac address in SQL Server

11 October 2007 13:57 by simonsabin

How to get away with murder

EXECUTE AS SomeoneElse

# re: How to find a Mac address in SQL Server

16 October 2007 09:42 by Wanderer

It doesn’t happen often, but every now and again, there is a little humour in the DBA land. If you laugh at this, your probably a DBA (or could become one):

http://xkcd.com/327/