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

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.