Asp.net Queries

write this script on that aspx page from which the page is redirect to popup window   <script type="text/javascript">     function popup(url,width,height) {     var left = (screen.width - width) / 2;     var top = (screen.height - height) / 2;     var params = 'width=' + width + ', height=' + height;     params += ', top=' + top + ', left=' + left;     params += ', toolbar=no';     params += ', menubar=no';     params += ', resizable=yes';     params += ', directories=no';     params += ', scrollbars=yes';     params += ', status=no';     params += ', location=no';     newwin = window.open(url, 'd', params);     if (window.focus)     {         newwin.focus()     }     return false;  ...

Merge Use the MERGE statement to select rows from one table for update or insertion into another table. The decision whether to update or insert into the target table is based on a condition in the ON clause. It is a new feature of Oracle Ver. 9i. It is also known as UPSERT i.e. combination of UPDATE and INSERT. For example suppose we are having sales and sales_history table with the following structure.   SALES Prod Month Amount SONY SONY SONY SONY SONY SONY JAN FEB MAR APR MAY JUN 2200 3000 2500 3200 3100 5000 SALES HISTORY Prod Month Amount SONY SONY SONY AKAI JAN MAR APR JAN 2000 2500 3000 3200 Now we want to update sales_history table from sales table i.e. those rows whi...