My Work
My Blogs
Hotlinks
Tag Archives: stored procedure
How to TWEET from a SQL CLR Stored Procedure
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 .net, .net assembly, .net Common Language Runtime, C#, CLR, CLR SPROC, sproc, sql server 2005, stored procedure, tweet, twitter
12 Comments
I built a calendar in a tSQL SPROC
Here’s a blast from the past that I recently found in my archives. It’s a novelty stored procedure I wrote during my MS SQL 2000 DBA days. Back when I wrote this sproc, I was really big into writing calendar … Continue reading
Posted in SQL
Tagged calendar, mssql, sproc, stored procedure, table variables, tsql, tsql date functions
Leave a comment
