SQL Server Tricks

Convert Integer to Decimal

select isnull(format(99,'N'),0) as [integer to decimal]

Convert Decimal  to Integer

select convert(int,150.6,0) as [Decimal to Integer]

Find Recent Created Stored Procedure, Date

SELECT name, crdate, refdate

FROM sysobjects

WHERE type = 'P'

ORDER BY refdate desc