SELECT o.type_desc AS ROUTINE_TYPE ,o.[name] AS ROUTINE_NAME ,m.definition AS ROUTINE_DEFINITION FROM sys.sql_modules AS m INNER JOIN sys.objects AS o ON m.object_id = o.object_id WHERE m.definition LIKE '%keyword% |
Tag / MSSQL
Show all triggers in a database in MSSQL
SELECT object_name(id), object_name(deltrig), object_name(instrig), object_name(updtrig) FROM sysobjects WHERE xtype ='U' AND (deltrig > 0 OR instrig > 0 OR updtrig > 0) |
Display SQL result horizontally (comma separated) in MSSQL 2005
Here is a sql statement to display a column result horizontally.
e.g.
record1, record2, record3, record4, ... recordx
DECLARE @id_list VARCHAR(MAX) --varchar max works for SQL 2005 or above SELECT @id_list = CASE WHEN @id_list IS NULL THEN CONVERT(VARCHAR,column1) ELSE @id_list + ',' + CONVERT(VARCHAR,column1) END FROM table1 SELECT @id_list |