Tuesday, January 15, 2008

SQL - Get Routine Information

You can use this query to get information about a particular columns existance in a stored procedure.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%ticketprice%'