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%';

How To Convert ASCII Code To String

char.ConvertFromUtf32(34)

how to fetch record which is not null

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

Scientists erase bad memories from brain

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

Courtesy
Yahoo