Geeks With Blogs

News This blog has moved to
Shailen Sukul blog May 2006 Entries
Script to search in Stored Proces

Script to search in stored procs

select  upper(SysObjects.Name),SysComments.Text
from  SysObjects, SysComments  
where  SysObjects.type='P'
and (SysObjects.ID = SysComments.ID)
and SysComments.Text like '%SearchString%'

Posted On Friday, May 26, 2006 12:15 PM

Sql Server Stored Procedure oddity
I ran across this weird problem while debugging a stored procedure in Sql Server 2000. Here's a sample stored procedure: drop procedure p1gocreate procedure p1as create table #t1( col1 int identity(1,1), col2 datetime, col3 int) select *from #t1 return update #t1set col3 = col2return Ok, notice that I have a return statement after the first select. That is my exit point for now because I am debugging so I am not interested in the section after that. Also notice that the update statement will throw ......

Posted On Monday, May 8, 2006 9:29 AM

Copyright © Shailen Sukul | Powered by: