Programming Skills

AngularJS Expression

Sharing Knowledge is always advisable

AngularJS Expressions

AngularJS expressions can be written inside double braces: {{ expression }}.

AngularJS expressions can also be written inside a directive: ng-bind="expression".

AngularJS will resolve the expression, and return the result exactly where the expression is written.

AngularJS expressions are much like JavaScript expressions: They can contain literals, operators, and variables.

Example {{ 5 + 5 }} or {{ firstName + " " + lastName }}

<!DOCTYPE html>
<html>
<script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.4.8/angular.min.js"></script>
<body>

<div ng-app="">
<p>My first expression: {{ 5 + 5 }}</p>
</div>

</body>
</html>

Result will be

My first expression : 10

f you remove the ng-app directive, HTML will display the expression as it is, without solving it:

ng-init is used to initialize data.

Like JavaScript expressions, AngularJS expressions can contain literals, operators, and variables.

Unlike JavaScript expressions, AngularJS expressions can be written inside HTML.

AngularJS expressions do not support conditionals, loops, and exceptions, while JavaScript expressions do.

AngularJS expressions support filters, while JavaScript expressions do not.

AngularJS arrays are like JavaScript arrays:

<div ng-app="" ng-init="points=[1,15,19,2,40]">

<p>The third result is <span ng-bind="points[2]"></span></p>

</div>

Result will be

the third result is 19

AngularJs objects are same as javascript objects

Result

The name is Doe

AngularJS Basic

Sharing Knowledge is always advisable

WHAT is AngularJS?

AngularJS is a JavaScript framework that is intended to make it easier to implement RIA web applications.

AngularJS is based on the MVC pattern (Model View Control). Therefore AngularJS separates your RIA application into models, views and controllers. The views are specified using HTML + AngularJS's own template language. The models and controllers are specified via JavaScript objects and JavaScript functions. Thus, the views are specified declaratively, as HTML normally is, and the models and controllers are specified imperatively, as JavaScript normally is.

AngularJS extends HTML with ng-directives.

The ng-app directive defines an AngularJS application.

The ng-model directive binds the value of HTML controls (input, select, textarea) to application data.

The ng-bind directive binds application data to the HTML view.

<!DOCTYPE html>

<html>

<head>

</head>

<div>

<h1>

Hello World!</h1>

<p>

I'm AngularJS. Here is your AJAX-powered text: <span style="color: fuchsia;"> <b><p ng-bind="txt"></p></b></h1>

<p>

Enter message:

</div>

</body>

</html>

AngularJS starts automatically when the web page has loaded.

The ng-app directive tells AngularJS that the <body> tag is the "owner" of an AngularJS application.

The ng-model directive binds the value of the input field to the application variable txt.

The ng-bind directive binds the innerHTML of the <p> element to the application variable txt.

Temp Table Vs Table Variable

1. SYNTAX

Below is the sample example of Creating a Temporary Table, Inserting records into it, retrieving the rows from it and then finally dropping the created Temporary Table.

-- Create Temporary Table

CREATE TABLE #Customer 

(Id INT, Name VARCHAR(50))

--Insert Two records

INSERT INTO #Customer

VALUES(1,'Basavaraj') 

INSERT INTO #Customer 

VALUES(2,'Kalpana')

--Reterive the records

SELECT * FROM #Customer

--DROP Temporary Table

DROP TABLE #Customer

Below is the sample example of Declaring a Table Variable, Inserting records into it and retrieving the rows from it.

-- Create Table Variable

DECLARE @Customer TABLE

(

 Id INT,

 Name VARCHAR(50)   

)

--Insert Two records

INSERT INTO @Customer 

VALUES(1,'Basavaraj') 

INSERT INTO @Customer 

VALUES(2,'Kalpana')

--Reterive the records

SELECT * FROM @Customer

2. MODIFYING STRUCTURE

we can use DDL statements i.e. Alter,Create,Drop

--Create Temporary Table

CREATE TABLE #Customer

(Id INT, Name VARCHAR(50))

GO

--Add Address Column

ALTER TABLE #Customer 

ADD Address VARCHAR(400)

GO

--DROP Temporary Table

DROP TABLE #Customer

GO

Table Variables doesn’t support DDL statements like ALTER, CREATE, DROP etc, implies we can’t modify the structure of Table variable nor we can drop it explicitly.

3. STORAGE LOCATION

One of the most common MYTH about Temporary Table & Table Variable is that: Temporary Tables are created in TempDB and Table Variables are created In-Memory. Fact is that both are created in TempDB.

4. TRANSACTIONS

Temporary Tables support use of transactions defined by the user.

Table variables doesn’t support explicit transactions defined by the user.

5. USER DEFINED FUNCTION

Temporary Tables are not allowed in User Defined Functions. Table Variables can be used in User Defined Functions.