Friday, January 17, 2014

Fetch All td from table and add events dynamicly with JavaScript No jQuery

Table

  <table  border="1" cellpadding="0" cellspacing="0" width="600px" >
   <tbody class='tbodyClass'>
 
      <tr>
         <td id="a" class="a">
         AAAAAAAA
         AAA
         aAA
         </td>
         <td class="b"></td>
      </tr>
        <tr>
         <td id="b" class="a">
         BBB  <br />
         BBB<br />
         BBB<br />
         </td>
         <td class="b"></td>
      </tr>
        <tr>
         <td   id="c"  class="a">
         CCC<br />
         CCC<br />
         CCC<br />
         </td>
         <td class="b"></td>
      </tr>
        <tr>
         <td   id="d"  class="a">
         DDD<br />
         DDD<br />
         DDD<br />
         </td>
         <td class="b"></td>
      </tr>
       </tbody>
   </table>

Script

 <script type="text/javascript">

      function clickCellTest() {
         alert(this.id);
      }
      window.onload = function MaheshTest() {
         var ab = document.getElementsByClassName('tbodyClass')[0];

         ab = ab.getElementsByTagName('td');
         for (var i = 0; i < ab.length; i++) {
            var element = ab[i];
            element.addEventListener("click", clickCellTest, false);
         }
      }

   
   </script>

Friday, November 22, 2013

Get all column name for all the table name used in database.

select TABLE_NAME, column_name, ' is used to ' as 'Description'  from information_schema.columns
 where table_name in

 (
 select TableName from (
 SELECT ta.name as TableName
 ,SUM(pa.rows) RowCnt
 FROM sys.tables ta
 INNER JOIN sys.partitions pa
 ON pa.OBJECT_ID = ta.OBJECT_ID
 INNER JOIN sys.schemas sc
 ON ta.schema_id = sc.schema_id
 WHERE ta.is_ms_shipped = 0 AND pa.index_id IN (1,0)
 GROUP BY sc.name,ta.name
 having SUM(pa.rows) >0
 ) v
 )
 and column_name not in('clm1','clm2','clm3','clm4','clm5','clm6','clm7')-- add column which you did not want to add in list
order by TABLE_NAME

copy with header and paste in excel.