Default Field Value at Table Creation Time

Syntax:

[FieldName] type CONSTRAINT [constraint_name] DEFAULT default_value

Example:

CREATE TABLE [Clients]

(

    ClientID  bigint   NOT NULL IDENTITY(1,1) CONSTRAINT [PK_Clients] PRIMARY KEY,

    CreatedOn datetime NOT NULL CONSTRAINT [DF_Clients_CreatedOnUtc] DEFAULT GETDATE()

    ...

)

And for an already created table:

ALTER TABLE Clients

ADD CONSTRAINT [DF_Clients_CreatedOn] DEFAULT GETDATE() FOR CreatedOn

Unique Fields at Table Creation Time

Sintax:

[FieldName] type CONSTRAINT [constraint_name] UNIQUE

Example:

CREATE TABLE [Clients]
(
    ClientID int NOT NULL IDENTITY(1,1) CONSTRAINT [PK_Clients] PRIMARY KEY,
    ServiceCode varchar(50) NOT NULL CONSTRAINT [UQ_Clients_ServiceCode] UNIQUE
    ...
)

Example 2:

CREATE TABLE [Clients]
(
    ClientID int NOT NULL IDENTITY(1,1) CONSTRAINT [PK_Clients] PRIMARY KEY,
    ServiceCode varchar(50) NOT NULL,
    CONSTRAINT [UN_Clients_Unique] UNIQUE (ClientID, ServiceCode)
    ...
)

jQuery ajax function template

Example

$.ajax({
    url: "/Home/Index",
    data: { email: email, username: username, etc: etc },
    success: function (data) {
        debugger; // remove debugger before check-in.
        $("#somelabel").text(data.SomeText);
    },
    type: "POST",
    dataType: 'json'
});

Another example

$.ajax(
{
    url: "/Account/LogOn",
    type: "POST",
    dataType: 'json',
    data: {
        username: $("txtUserName").val(), 
        password: $("txtPassword").val(),
        rememberMe: $("#chkRememberMe").is(':checked')
    },
    success: function (mydata) {
        if(mydata.Success) {
            alert(mydata.WelcomeMessage);
        }
        else{
            alert(mydata.Error);
        }
    }
});