Shrinking Tweets with Tweet-SQL

To get your point across on Twitter you sometimes have to try and shorten your tweets. This can be a pain for anyone over 30 who doesn’t know txtspk. Thankfully some clever chap has come to the rescue with TweetShrink and I’ve integrated it into Tweet-SQL. Here’s how you use it;

DECLARE @shrunk VARCHAR(140),
		@shaved INT;

EXEC dbo.tweet_util_tweetShrink 'For some strange reason I have developed a tendency to think every new version of Windows is more of a resource pig.', @shrunk OUTPUT, @shaved OUTPUT;

-- The shortened Tweet
SELECT @shrunk AS shrunkTweet;
-- How may characters have been shaved off?
SELECT @shaved AS shaved;

A future version of Tweet-SQL will include this functionality along with a few more cool surprises.