I occasionally need to return a month and year but would like the month as a 3 letter abbreviation instead of a number. This is useful for reports.
Usage:
Select mydb.dbo.udfmmm_yyyy(Getdate())
Creating a PDF from a Stored Procedure in SQL Server
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.
2019-09-20 (first published: 2003-08-26)
73,133 reads