Transact-SQL RFC822 DateTime UDF

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

Read More...

---