My Thoughts & Views

Archive for December 28th, 2007

If you ask software engineers about how the compiler works? Most of them give you an alien look.

Here is how the compiler works :

Advertisements

1. Following Query displays all the table names.

Query : select name from sys.objects where type=‘u’ ;

2. Following Query displays all the columns in a table

Query : select Table_Name,Column_Name from INFORMATION_SCHEMA.COLUMNS ;


Blog Stats

  • 70,353 hits
December 2007
M T W T F S S
« Nov   Jan »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Top Posts

Top Clicks

  • None
Advertisements