>declare @LongName varchar(max) >--set @LongName = '' >-- >--select @LongName = @LongName + ' ' + ISNULL(FirstName,'') from Registration >--select @LongName as LongName >set @LongName = '' >select name from sys.procedures order by name >SELECT @LongName = @LongName + char(13) + OBJECT_DEFINITION(OBJECT_ID) from sys.procedures where Name Like 'Registration%' >print @LongName>
declare @LongName varchar(max) set @LongName = '' select name from sys.procedures order by name SELECT @LongName = @LongName + char(13) + OBJECT_DEFINITION(OBJECT_ID) from sys.procedures where Name Like 'Registration%' AND is_ms_shipped = 0 --- Only user SP print @LongName SELECT @LongName, LEN(@LongName)