Tuesday, March 31, 2009

how to find the list of stored procedure in the database






Sql Server 2005

SELECT * FROM sys.procedures;


User Procedure

SELECT * from sys.objects where type='p' and is_ms_shipped=0 and [name] not like 'sp[_]%diagram%';



Friday, March 20, 2009

Friday, March 13, 2009

how to fetch record which is not null

SELECT * FROM <table name> WHERE <column name> IS NOT NULL



Thursday, March 12, 2009

Scientists erase bad memories from brain

It may soon be possible to erase bad memories from the human brain
more

Courtesy
Yahoo



Creative Commons License
Disclaimers:We have tried hard to provide accurate information, as a user, you agree that you bear sole responsibility for your own decisions to use any programs, documents, source code, tips, articles or any other information provided on this Blog.