Basic SQL queries

Create a new table :

Create table tblEmployee (EmployeeID int primary key identity, Name VARCHAR(30), Gender VARCHAR(10), City VARCHAR(40), DeptID int)

Fetching data from table :

Select * from tblEmployee

Insert sample data to table :

Insert into tblEmployee values (10117, 'Venu', 'Male', 'Hyderabad',2)
Insert into tblEmployee values (10118, 'Naresh', 'Male', 'NewYork', 3)
Insert into tblEmployee values (10119, 'Varun', 'Male', 'Secunderabad',3)
Insert into tblEmployee values (10120, 'Angel', 'Female', 'London',1)

Add new column after table created :

ALTER table tblEmployee ADD DepartmentName int)

Making column as NOT NULL :

ALTER TABLE [tblEmployee] ALTER COLUMN [EmployeeID] int NOT NULL

Making column as PRIMARY KEY :

ALTER TABLE tblEmployee ADD PRIMARY KEY (EmployeeID)


Create table tblDepartments (ID int PRIMARY KEY, Name VARCHAR(30))
Insert into dbo.tblDepartments values (1, 'HR')
Insert into dbo.tblDepartments values (2, 'IT')
Insert into dbo.tblDepartments values (3, 'Engineering')

Table name change :

EXEC sp_rename 'Departments','tblDepartments'

Select * from tblDepartments

Stored procedure for adding new employee :

Create procedure spAddEmployee
@Name nvarchar(50),
@Gender nvarchar(10),
@City nvarchar(10),
@DateOfBirth DateTime
as
Begin
Insert into tblEmployee (Name, Gender , City, DateOfBirth)
values (@Name, @Gender, @City,@DateOfBirth)

End

JavaScript - Array operations

JavaScript - Array operations

var myArray = [];

//push - Adds new element to the end of the array
for (var i = 0; i < 6; i++) {
    myArray.push(i);
}

document.write("Array elements are : <br/>");
for (var i = 0; i < myArray.length; i++) {
    document.write(myArray[i] + "<br/>");
}

document.write("Array length is : " + myArray.length + "<br/> <br/>");

//pop - removes last element of the array.
myArray.pop();

document.write("Array elements after pop operation : <br/>");
for (var i = 0; i < myArray.length; i++) {
    document.write(myArray[i] + "<br/>");
}

document.write("Array length is : " + myArray.length + "<br/> <br/>");

//Shift operation - Remove the first item of an array
myArray.shift()


document.write("<br/>Array elements after shift operation : <br/>");
for (var i = 0; i < myArray.length; i++) {
    document.write(myArray[i] + "<br/>");
}
document.write("<br/>");

//Unshift operation - Add new items to the beginning of an array
myArray.unshift(100, 101);

document.write("Array elements after unshift operation : <br/>");
for (var i = 0; i < myArray.length; i++) {
    document.write(myArray[i] + "<br/>");
}

//Reverse operation
myArray.reverse();

document.write("Array elements after Reverse operation : <br/>");
for (var i = 0; i < myArray.length; i++) {
    document.write(myArray[i] + "<br/>");
}

//Sort Operation
//Descending order --- myArray.sort(function (a, b) { return a - b;}).reverse();
myArray.sort(function (a, b) { return a - b;});

document.write("Array elements after Sort operation : <br/>");
for (var i = 0; i < myArray.length; i++) {
    document.write(myArray[i] + "<br/>");
}

//Splice operation
myArray.splice(2, 2);

document.write("Array elements after Splice operation : <br/>");
for (var i = 0; i < myArray.length; i++) {
    document.write(myArray[i] + "<br/>");
}

myArray.splice(1,0,5,10);
document.write("Array elements after Splice operation : <br/>");
for (var i = 0; i < myArray.length; i++) {
    document.write(myArray[i] + "<br/>");
}