Posts

Showing posts with the label 2012

GOOGLE privacy policy New Rule 1 March 2012 (How to turn the settings off to stop sharing your personal information)

Image
Google has implemented new privacy policy from 1st March 2012. The change means private data collected by one Google service can be shared with its other platforms including YouTube, Gmail and Blogger.   Take following steps to limit Google's ability to track and record your every move online. What this mean is that while Google will continue gathering and storing information about web history it will make all data anonymous. Google will not associate your web history information with your online account. Follow the following steps 1. Go to the Google homepage and sign into your account. 2. Click the drop-down menu next to your name in the upper-right hand corner of your screen. 3. Click accounts settings 4. Find the "Services section" 5. Under "Services" there is a sub-section that reads "View, enable, disable web history." Click the link next to it that reads: "Go to Web History."  (Note: When you click "Go to We...

How to get Table structure/Column information using SQL Query

There are different ways to fetch database 'Tables' or 'Views' structure INFORMATION_SCHEMA views: Microsoft has introduced 20 different views to fetch helpful database information as part of SQL Server database 2005 and onward. We will use 'columns' view to fetch table structure information In my openion,  this is the easiest way to fetch table structure information e.g., column name, data type, size, isnullable, table schema etc. to fetch table structure select * from INFORMATION_SCHEMA.columns where TABLE_NAME = 'tablename' or select column_name, data_type, is_nullable, character_maximum_length from INFORMATION_SCHEMA.columns where TABLE_NAME = 'tablename' using database name as prefix select *  from database. INFORMATION_SCHEMA.columns where TABLE_NAME = 'tablename' ----------------------------------- syscolumns & systypes: Getting columns and other structural information of a table select name ,...