Database

declare @str as varchar(100)
declare @startposition int
declare @endposition int
declare @stopingcondition int
declare @delimeter char(1)
set @startposition = 0
set @stopingcondition = 15
set @delimeter =''
set @str = 'I would like to get first 15 word from a long sentence but not sure how to do this. I guess I should be looking for 15th space in the word but not sure how to do this could some please help?' -- original data

--Program starts
;with num_cte as
(     
      select 1 as rn
      union all
      select rn +1 as rn 
      from num_cte 
      where rn <= len(@str)
)
, get_all_delimited_char_pos_cte as
( 
      select  row_number()over(order by rn) cnt ,rn,chars       
      from num_cte
      cross apply( select substring(@str,rn,1)  AS chars) splittedchars 
      where chars = @delimeter      
)
select @endposition = rn from get_all_delimited_char_pos_cte where cnt = @stopingcondition
select SUBSTRING(@str,@startposition,@endposition) as First15thWords

I would like to get first 15 word from a long sentence but not sure

declare @str as varchar(100)
set @str = 'I would like to get first 15 word from a long sentence but not sure how to do this. I guess I should be looking for 15th space in the word but not sure how to do this could some please help?' -- original data

select SUBSTRING(@str,0,68)

System.Data.DataSet myDS = new System.Data.DataSet();
System.Data.SqlClient.SqlDataAdapter myAdaptor 
    = new System.Data.SqlClient.SqlDataAdapter("Execute myProcedure;"
     ,new System.Data.SqlClient.SqlConnection(myConnectionString));
myAdaptor.Fill(myDS)

The Man from U.N.C.L.E. wrote:

You can't.

Declare @GetDBNames sysname
Declare @DynSql nvarchar(max)
declare @result table ([Database_Name] nvarchar(128), [Stored Procedure Name] sysname)

Declare DBNames cursor for 
Select '['+name+']' from master.dbo.sysdatabases 

open DBNames
FETCH NEXT FROM DBNames into @GetDBNames

WHILE @@FETCH_STATUS=0
BEGIN

SET @DynSql = '
Select Specific_Catalog as Database_Name, Routine_Name as ''Stored Procedure Name''
From '+ @GetDBNames+'.Information_Schema.Routines '


insert @result exec sp_executesql @DynSql 

FETCH NEXT FROM DBNames into @GetDBNames
END
Close DBNames
Deallocate DBNames
select * from @result