Monday, December 22, 2008

Nilgiri's Cake Exhibition

Bangalore hosted the 36th annual Nilgiri's Cake Exhibition, this december

Venue for the show is St. Jospeh's Indian High School, Vittal Mallya Road, Bangalore (close to MG Road, drive straight down from MG road and after first signal on the left you can see the school - near to Kandeerava Indoor Stadium) .
The Cake Exhibition is clubbed with the National Consumer Fair 2008.

The theme of the cake exhibition is the 7 new wonders of the world. The highlight of the exhibition was the 16 Feet by 58 feet Buckingham Palace.
Other Exhibits include , The Taj Mahal of India, Christ Redeemer of Brazil, The Great Wall of China, Petra of Jordan, Machu Picchu of Peru, Colosseum of Rome and The Pyramid at Chichen Itza

Nearly 20,000 man-hours and 9.5 tonnes of sugar were used in creating the cakes

After the exhibition, the cakes are usually distributed to orphanages.

For those who missed out the cakes here are the pics

Entry Ticket : 30 rs/head
Parking : 20 rs (car park) 10rs(bike)

Huge Parking lot available.

The event is on the school ground with a closed interiors. The crowd management is very bad.Toilets are not availble and there was hush hush with ladies toilets as drunken guys were near the ladies toilet on the first floor of the school, and the ladies toilet didnot have any water or mugs and to the least even the doors didnot have any latches. Please avoid the toilets.

Thursday, December 11, 2008

Search for Text + String within a Stored Proc in SQL

I was searching for a Query in MS SQL for searching a string inside the available stored procedure, and found this query.

Query with the Objects and search with the content(definition) of the stored proc

select as [StoredProc] from sys.objects o
inner join
sys.sql_modules m
o.object_id = m.object_id
m.definition like '%[String to be Searched]%'

or we can directly query into the Sys.Procedures

SELECT Name FROM sys.procedures