Tech Tutorials Database
GeekArticles XML RSS

Transact-SQL RFC822 DateTime UDF

Category: RSS
Comments (0)

Printer Friendly Version Have you ever wanted to generate RSS from a Stored procedure? It's easy, until you get to the RFC822 date requirement! Believe it or not, I could not find this anywhere-- I actually had to cobble it together from pieces myself. Enjoy: IF OBJECT_ID('[dbo].[fnRFC822Date]', 'FN') IS NOT NULL DROP FUNCTION [dbo].[fnRFC822Date] GO CREATE FUNCTION [dbo].[fnRFC822Date] ( @Date datetime ) RETURNS nvarchar(70) AS BEGIN DECLARE @display nvarchar(70) SET @display =...n


Sponsored Links

Read Next: Visual Studio.NET 2005 Beta 1: The Lowdown