Posted on July 18, 2008 by Lisa Zhou
A little useful script for searching in stored procedures.
SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE ‘%searchtext%’
AND OBJECTPROPERTY(id, ‘IsProcedure’) = 1
GROUP BY OBJECT_NAME(id)
Filed under: SQL Server, Uncategorized | Leave a Comment »
Posted on July 15, 2008 by Lisa Zhou
Lately I’ve been doing some reading on javascript and JQuery. This article here isĀ really good in explaining how the function in javascript works, and how you can use it as an object, override functions and other other really helpful information.
http://www.permadi.com/tutorial/jsFunc/
Filed under: Javascript, Uncategorized | 1 Comment »
Posted on April 1, 2008 by Lisa Zhou
With the .net auto complete control, there is an attribute enablecache which tells the auto-complete to use caching or not. If this attribute is set to true, typing the same search text within a set number of seconds, instead of retrieving the data again from the database, the previous search results will be used.
Although caching [...]
Filed under: Ajax.Net, autocomplete | 3 Comments »