Chandra Bhushan Prasad

REATE PROC getBusinessLineHistory AS BEGIN SELECT * FROM sys . databases END GO sp_configure 'Show Advanced Options' , 1 GO RECONFIGURE GO sp_configure 'Ad Hoc Distributed Queries' , 1 GO RECONFIGURE GO SELECT * INTO # MyTempTable FROM OPENROWSET ( 'SQLNCLI' , 'Server=(local)\SQL2008;Trusted_Connection=yes;' , 'EXEC getBusinessLineHistory' ) SELECT * FROM # MyTempTable

Abstraction is a process of hiding the implementation details and displaying the essential features. Example1 : A Laptop consists of many things such as processor, motherboard, RAM, keyboard, LCD screen, wireless antenna, web camera, usb ports, battery, speakers etc. To use it, you don't need to know how internally LCD screens, keyboard, web camera, battery, wireless antenna, speaker’s works.  You just need to know how to operate the laptop by switching it on. Think about if you would have to call to the engineer who knows all internal details of the laptop before operating it. This would have highly expensive as well as not easy to use everywhere by everyone. So here the Laptop is an object that is designed to hide its complexity. How to abstract: - By using Access Specifiers .Net has five access Specifiers Public -- Accessible outside the class through object reference. Private -- Accessible inside the class only through member functi...