Using TinyURL with Tweet-SQL

As every post to Twitter is limited to 140 characters it’s important we are able to squeeze as much as we can out of it. To help users of Tweet-SQL with this I’ve integrated TinyURL into version 2 of the product. Here’s how you use it;

DECLARE @long_url NVARCHAR(1000),
	@short_url NVARCHAR(100);

SET @long_url = 'http://rover.ebay.com/rover/1/711-53200-19255-0/1?type=3&campid=5336224516&toolid=10001&customid=tiny-hp&ext=unicycle&satitle=unicycle';

-- Make the long url short!
EXEC dbo.tweet_util_shortenUrl @long_url, @short_url OUTPUT;

SELECT @short_url AS TinyURL;