Ian Bailey

Useful bit of code, which I’m kinda putting here so I can access it easily. It will display the date created and last modified dates of stored procedures, which can be useful to see when you last made a code change etc! Anyway: SELECT name, create_date, modify_date FROM sys.objects WHERE type = ‘P’ ORDER BY [...]

Just had this problem, but its actually incredibly easy to solve, so thought i’d post an article on here incase anyone else has this problem. It’s quite simple really and there is a couple of examples below for T-SQL and MySQL. I’ve only used the T-SQL one in SQL Server 2005. SELECT TOP X fieldName [...]