You are currently browsing the daily archive for October 6, 2006.

 SAN FRANCISCO —  Google Inc. (GOOG) is introducing a new search service that only a geek could love.

The Web search leader said late on Wednesday it is introducing Google Code Search, a site that simplifies how software developers search for programming code to improve existing software or create new programs.

Google product manager Tom Stocky said the Mountain View, California-based company is set to help programmers sift through billions of lines of computer source code using its familiar search box to uncover snippets of reusable software.

Google code search

 O’Reilly Code Search 

Enter search terms to find relevant sample code from nearly 700 O’Reilly books.
The database currently contains over 123,000 individual examples, composed of 2.6 million lines of code — all edited and ready to use.

Oreilly code search

//how to use template table of variables
//usage: execute delete_prodorder ‘AB5002-X’

create procedure delete_prodorder 
@ProdOrder nvarchar(30) 
as 
begin 
    --create temp table 
    create table #MyTableVar (OrgSpanKey    nvarchar(30)); 
    delete #MyTableVar 
    delete OPER_SPAN_RSRC where PROD_ORDER = @ProdOrder 
    --insert data 
    insert into #MyTableVar select ORG_SPAN_KEY FROM ate.OPER_SPAN where PROD_ORDER = @ProdOrder 
    delete OPER_SPAN where PROD_ORDER = @ProdOrder 
    --retreive data 
    delete ORG_SPAN where ORG_SPAN_KEY in (select * from #MyTableVar) 
    delete DOC_QUEUE WHERE  DOC_ID in (select distinct DOC_ID FROM OPER_DOC where PROD_ORDER = @ProdOrder) 
    update SHOP_MASTER set DTS_LAST_SYNC = null 
    drop table #MyTableVar 
end 
go

//how to use cursor to loop variables
//usage: replace your select cursor and stored procedure

declare	@prodOrder varchar(30) 
begin 
     declare prodOrderLoop cursor 
     for select ProdOrderId from Prod_Order 
     open prodOrderLoop 
     fetch next from prodOrderLoop into @prodOrder        

     while   @@FETCH_STATUS = 0 
        begin 
             execute delete_prodorder (@prodOrder) 
             fetch next from prodOrderLoop into @prodOrder 
        end     

     close prodOrderLoop 
     deallocate prodOrderLoop 
end 
go

//triggers example

create trigger OPERATION_DATA_UPD
on WOPR_DATA
after update
as
declare 

	@ProdOrder 		nvarchar(30),
	@OperNo			nvarchar(30),
	@OldOperStatus 		integer,	
	@QtyComplete		nvarchar(50),
	@Workspace 		nvarchar(50),
	@OldWorkspace		nvarchar(50),
	
	@s_notification1 	nvarchar(4000),
	@s_notification2 	nvarchar(4000),
	@s_notification3 	nvarchar(4000),
	@s_notification4 	nvarchar(4000),
	
	@string1 		nvarchar(4000),
	@string2 		nvarchar(4000),
	@string3 		nvarchar(4000),
	@string4 		nvarchar(4000)

begin
 
  select 	@ProdOrder 	= rtrim(a.WOPR3_ORD_REF), 	
  		@OperNo 	= cast(a.WOPR3_NO as varchar),
  		@QtyScrap 	= cast(a.WOPRQTY_SCRAPPED - b.WOPRQTY_SCRAPPED as varchar),
  		@Workspace 	= a.WOPR3_WORK, 		
  		@OldWorkspace 	= b.WOPR3_WORK,


  from 		Inserted  a, Deleted b  
  where       	a.WOPR3_ORD_REF = b.WOPR3_ORD_REF
  and         	a.WOPR3_NO = b.WOPR3_NO
  

  if @Workspace != @OldWorkspace 
  begin
    set  	@s_notification2='"
             Change'+@ProdOrder +'"'
    set  	@string2= 'd:\nmetric\notification\run-notification 127.0.0.1 20000 '+@s_notification2
    exec 	master..xp_cmdshell @string2  
    
    set  	@s_notification3='"
             INQUEUEChange'+@ProdOrder +'"'
    set  	@string3= 'd:\nmetric\notification\run-notification 127.0.0.1 20000 '+@s_notification3
    exec 	master..xp_cmdshell @string3      
  end   
end
go

Ref:
cursor overview
stored procedure
triggers I
triggers II
How to Share Data Between Stored Procedures