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

char.ConvertFromUtf32(34)




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