ezhov-da/sql-mssql-Текст объектов.sql

## sql-mssql-Текст объектов.sql
select
  ROW_NUMBER() over(order by sc.object_id) rowId, sc.object_id as [id], so.name, sc.definition as [text]
into #temp
from sysobjects so
left join sys.sql_modules sc
  on sc.object_id = so.id
where
  so.xtype in ('V' ,'FN', 'p', 'IF','TR')
	select
	ROW_NUMBER() over(order by sc.object_id) rowId, sc.object_id as [id], so.name, sc.definition as [text]
	into #temp
	from sysobjects so
	left join sys.sql_modules sc
	on sc.object_id = so.id
	where
	so.xtype in ('V' ,'FN', 'p', 'IF','TR')