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

How To Convert ASCII Code To String


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