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;

Using TinyURL with Tweet-SQL