Posts Tagged ‘Tweet-SQL’

Using the Twitter Search API with Tweet-SQL

Using the new version of Tweet-SQL you can consume data from the Twitter Search API. The data in Twitter Search is constantly updated with new tweets so anything you grab out of the API is near real-time. To perform a query with Tweet-SQL run the following T-SQL; ?View Code TSQLEXEC dbo.tweet_src_search ‘MC Frontalot’, null, null; […]

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; ?View Code TSQLDECLARE @long_url NVARCHAR(1000), @short_url NVARCHAR(100);   SET […]

Tweet-SQL Version 2 Sneak Peek

Tweet-SQL is a Twitter Client for Microsoft SQL Server 2005 and above allowing you to interact with the Twitter API with standard T-SQL. The forthcoming version 2 of Tweet-SQL contains a host of new features and improvements. Here’s a sneak peek at what is coming in Tweet-SQL V2; New procedure allowing the use of the […]