Friday, November 20, 2009

How To Find The Number Of Live Connection In Database

SELECT DB_NAME(dbid) AS db, COUNT(dbid) AS connection FROM SYS.SYSPROCESSES WHERE dbid > 0
GROUP BY dbid

Monday, November 16, 2009

How To Duplicate Tab Or Clone Tab In Firefox

Just press the Ctrl key And drag The corresponding tab which is to Clone or duplicate

Supported By Firefox 3.x

Thursday, November 12, 2009

Regular Expression To Check Input With no space using JavaScript

<html>
    <head>
        <script>
            function validateContent(evt)
            {
             var pattern =     /^\w[a-zA-Z@#0-9.]*$/;
                 if(evt.value.search(pattern) == -1)
                 {
                    alert('Space not Allowed');
                    return false;
                 }
            }
        </script>
    </head>
    <body>
        <input type='text' onkeyup='return validateContent(this);' />
    </body>
</html>