Regular Expression for Password

var Password_REGEX = /^(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[_*#&%@]).{8,}$/;

It meets the following criteria:
- Minimum 8 charaters
- At least one number, one alphabet and one special charater.

Explicitly Set the MAX Size to SQLParameter Object C#

ByDefault, it will take max 400 characters. E.g.
sqlParameters[1] = new SqlParameter("@usernames", usernames);

We can explicitly Set the MAX Size to SQLParameter Object by the following way:
sqlParameters[1] = new SqlParameter("@usernames", SqlDbType.NVarChar, -1,
                                                usernames);

Use Multiple With Clause in one SQL Query

;With T (Name)
AS
(Select Top 1 Test1Name From Test), 
T2 (Name2) as
(
Select Top 1 Test2name From Test2
),
T3 (Name3) as
(
Select TOP 1 Test3Name From [Test3]
)
Select T.Name, T2.Name2, T3.Name3 From T, T2, T3

Validate Emails Array using Jquery

var emailsString = "amit.jain@test.com, amit@test.com, aj@test.com";

var emailValidator = /^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/;
var emails = emailsString.split(",");
var result = false;
var pattern = new RegExp(emailValidator);
        $.each(emails, function (i) {
            debugger;
            if (emails[i] != null && emails[i] != '') {
                var email = $.trim(emails[i]);
                result = pattern.test(email);
                if (!result) {
                    alert("Enter the valid email(s) and try again !");
                    return false;
                }
            }
        });