Archive for December 28th, 2007
How Compilers Work?
Posted on: December 28, 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 :
- In: SQL | SQL Server
- Leave a Comment
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 ;
