Monday, November 14, 2011

how to get the schema name and details of a table in database

just run this query in the database...

select column_name,* from information_schema.columns
 where table_name = '<TABLE_NAME>'
order by ordinal_name

Tuesday, October 18, 2011

How do i get a tick in excel?

just select the family Webdings  and type "a"
then copy the same use where required.
like this if required.

Section\DivisionDiv1         
Section 1a