Geeks With Blogs
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: