Category Archives: tsql

Transact-SQL (T-SQL) is Microsoft’s and Sybase’s proprietary extension to SQL. Transact-SQL is central to using SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.

Selecting random ids using TOP and a CTE

Posted on 09/29/2010 by Eric Fickes

While testing visualizations in a Flex application, I needed to do some underlying data cleanup in SQL Server.  One of my tasks was to manually update an entity table and set the status column to one of three possibilities.  Status … Continue reading →

Posted in database, SQL, tips and tricks, tsql | Tagged , , , , , , , | Leave a comment

What if you want to PIVOT against a text column?

Posted on 04/30/2010 by Eric Fickes

If you’ve ever worked with or researched SQL Server’s PIVOT function, you probably noticed most of the samples pivot against an id column.  Typically an int column like EmployeeID, or StoreID.  That’s fine and dandy, but what happens when you … Continue reading →

Posted in database, microsoft, SQL, tips and tricks, tsql | Tagged , , , , , , , | 2 Comments

Incorrect syntax near the keyword ‘table’ in TSQL

Posted on 04/07/2010 by Eric Fickes

Ran into something little that I know I’m going to forget if I don’t write down. It appears that when using a TABLE variable in tsql ( SQL Server 2005 ), you must DECLARE that variable on it’s own line, … Continue reading →

Posted in database, microsoft, SQL, tsql | Tagged , , , , , | 4 Comments

How to TWEET from a SQL CLR Stored Procedure

Posted on 03/03/2010 by Eric Fickes

Here’s another SQL Server 2005 geek out moment, a CLR SPROC that tweets to Twitter. Big shoutout to Danny Battison for sharing the C# code to post to Twitter. This is what got me started on the C# side of … Continue reading →

Posted in .net, C#, database, microsoft, SQL, tips and tricks, tsql, twitter | Tagged , , , , , , , , , , | 12 Comments