Tuesday, January 28, 2014

search text in a stored procedure


declare @Text varchar(max);
set  @Text =1016
SELECT DISTINCT o.name AS Object_Name,o.type_desc
FROM sys.sql_modules m
INNER JOIN sys.objects o
ON m.object_id=o.object_id
WHERE m.definition Like '%'+@Text+'%'

Wednesday, January 22, 2014

Get List of All Database created on server


SELECT name, user_access_desc, is_read_only, state_desc, recovery_model_desc,create_date
FROM sys.databases ORDER BY create_date DESC

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>