TRUNCATE TABLE master..sysdatabases

...and other neat SQL Server tricks
posts - 51, comments - 60, trackbacks - 14

SQLBits - Unicode Porn

We've just finished up a fantastic event at SQLBits X in London!  If you've never been to SQLBits and you can make it to the UK, I highly recommend it.  If you didn't attend, here's what you missed.

Meanwhile, for those who attended the Lightning Talk sessions and were disappointed that I ran out of time, here's the last part that you would have seen:

/*    How to Lose Friends and Irritate People...With Unicode!
    Rob Volk
    SQLBits X - London - March 31, 2012
*/

-- some sexy SQL
DECLARE @oohbaby TABLE(i INT NOT NULL UNIQUE,
uni_char AS NCHAR(i),
hex AS CAST(i AS BINARY(2)))
INSERT @oohbaby VALUES(664),(1022),(1023),(1120),(1150),(8857),(11609),(42420),(42427)

-- change results font to larger size, some only work in grid font
SELECT * FROM @oohbaby

SELECT NCHAR(1022) + NCHAR(1023) AS Page3Girl

It's probably better that you run this yourself, in the privacy of your own home/office, you know *wink* *wink* *nudge* *nudge* *say no more*

Print | posted on Saturday, March 31, 2012 12:25 PM | Filed Under [ Coolness Oddball ]

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET