AFAIK

Web part is a window of information inside webpage which can be edited, closed, minimised and dragged by the end user. We can say web part is providing the customization to the end user. Costomization can be, You can add or remove the control from the web page. Users can modify or edit the appearence of the window control Cantrol can be dragged into the different position of the web page. Different web part manager The web part manager manages all the webpart on a web page. Its not visible, but it control evey operation of the web control from back ground. web part manager can be operated in different modes( Browse, display, edit, catalog, connect ).       In browse mode we can not edit or drag the web part. In this mode we can only minimize and close the web part. Code:- Dim wpManager as new webpartmanager                    wpManager.Displaymode= WebpartManager.BrowseDisplayMode      In Design Mode we can drag and dropcontrols between webpart. Editor zone will provide th

Cursors       SQL statements are good for set at a time operations. So it is good for for handling a group of data. But there are scenarios when you want to update a row depending upon a some specific criteria, like loop through the rows and update the row. This time we are using cursors There are different steps to create cursors 1.Declare 2.Open 3.Fetch 4.Operation 4.Close and deallocate. Difference between delete and truncate statements? Delete is data manipulation language Truncate is  data definition language Truncate Cannot be rollnacked while delete can be Can not use trancate on a table referenced be foreign key Delete table sysntax logs the delete, truncate table does not log any information but it logs information about deallocation of data page of table. Delete can have criteria while truncate can not Trucate reset the identity of the table, while delete do not reset the identity.

Normalization Normalization is a set of rules used for the design of database tables and table are meant to be connected through relation ship. This set of rules are know as normalization. Normalization will avoid the repetitive entries, reduces the storage space, will avoid the need to restructure the table to accommodate new data. By doing the normalization you can increase the speed and flexibility of queries, summaries etc. First normal form Data must be broken into the smallest unit as possible and should not contain any repetitive group of fields. ID      Name                 Pet1   Pet2     Hours  Days  TotalHours/Week 1       Adarsh Soman    Cat    Cat2      5         5        25 Here name can be broken as first name and last name and pet repeating. So based on the first normal form the table will become as ID      First Name      LastName  Pet    Hours  Days  TotalHours/Week 1        Adarsh           Soman       Cat       5         5        25 Second Normal Form Ea