SQL SERVER 2008 R2 Evolution installation-step by step process

Download and extract the "SQL SERVER 2008 R2 Evolution" ISO/ZIP file.You will get the files as shown below.

2.click on Installation

3.click on "New installation or add features to an existing installation" to install a fresh copy.

4.Click on "OK"

5.Select "Evaluation" from drop down and click on "NEXT"

6.Accept the licence agreement and click on "Next"

7.Click on "Install"

8.Click on "Next"

9.Select "SQL Server feature installation" radio button and click on "NEXT"

10.Click on "Select All" and click on "NEXT"

11.Click on "Next"

12.Select "Default Instance" and click on "Next"

13.Click on "Next"

14.Give "NT AUTHORITY\SYSTEM" for all account names and select startup type as
"Automatic"/"Manual" and click on "Next"

15.Select the "Mixed mode" and specify the password for default username "sa" and click on "Add Current User" and click on "Next"

16.Click on "Add Current User" and click on "Next"

17.Select the first radio button and click on "Next"

18.Click on "Next"

19.Click on "Next"

20.click on "Install"

21.installation is in progress

22.once the installation is successfull you will get below window then click on close it.

You are done with installation.

Thanks
GSV

Walk-in for .Net Developer 2-6 years Experience at Freyr software services‏

Walk In Interviews on 1st August 2014 Friday for (2-6) years' experience .Net developer

Work Location: Hyderabad

Interview date: 1st August 2014 Friday

Time: 10:30 A.M to 3:30 P.M.

Eligibility Criteria:-
Qualification: Any BE / B.Tech/Mtech

Interview Venue Details:
Freyr solutions, Global Operations Center ,
Lanco Hills Technology Park,99LH 2nd floor,
Incubation Center,
Manikonda, Hyderabad - 500089,
India, Phone: +91 40 4848 0999 

Job Description:
*Good knowledge of visual studio 2008, 2010 using programming language C#.
*Should have good knowledge of:
*WindowsXP/2008/Windows 7.0
*XML (both data-focused and application configuration uses)
*Database platforms (MS SQL Server 2005, 2008)

Essential Skills:
*Strong ASP.Net with C# Exp
*Javascript
*JQuery
*AJAX
*WCF

Thanks
GVK Online Trainings-ADMIN TEAM 

MSBI Course Content

Hi  Team,

Please find the course content for MSBI (SSIS/SSAS/SSRS).

CLICK HERE

Duration: 45 Days
Daily: 1.30  Hr

Thanks
GPK

Excellent Opportunity for Oracle D2K or Pl/sql Professional for 1 - 3 years at Chain-Sys

Chain-Sys:

Chain-Sys is the fast growing Business Consulting and Product Development company with key expertise in Business Process Automation - Solutions. Our Operations launched in the year 1998 at Lansing, Michigan USA, supported by our Global Development Center in Chennai, INDIA. Our Global Business Operations is spread across UK, Singapore & US and National Operations across major metros like Chennai, Bangalore, Coimbatore, Mumbai & Delhi.


Candidate Profile:
* Min 1 + years of experience in any of the programming languages like PL/SQL,
forms & reports, D2k.
* Good in communication & interpersonal skills.
* Adaptable, learning nature.
* Should be willing to work in different project locations.

Job Description:
* Will be trained in development and customization of Oracle ERP.
* Will be trained in the implementation of Oracle ERP (R12 - E-business suite).

Pre-requisites:
* Minimum of 1 to 3 years exp
* Good communication skill
Location: Chennai

Interested candidates pls mail your Cv to sathish.ms@chain-sys.com with the below mentioned details asap
Name:
Exp:
Curr ctc:
Expected ctc:
Notice period:

Thanks
GVK Online Trainings- ADMIN TEAM

Urgent Requirement for Dot Net (0-1yrs) in HYD

Job Description

1. A Strong candidate with knowledge on ASP.NET ,C#, Javascript, AJAX, Web services, WCF .
2. Excellent problem solving skills with Datastructures and Algos
3. Strong diagnostic & troubleshooting skills
4. Knowledge of working with CSS Styles.

5.Excellent Communication skills required.

Qualification

• BE/BTech/ME/MTech/MCA or any relevant degree.

Experiance : Fresher

CTC: Negotiable

Location:Hyderabad

Joining Period - 30 to 45 days

 Min Experience: 0 Yr  Max Experience: 1 Yr

Location: Hyderabad

Max Salary: Rs 2.5 Lakh / Yr

 Drop Resumes at jobs@techringers.in

Thanks
GVK Online Trainings-ADMIN TEAM

Tera Data Openings at Value Labs for exp3-6 years

Thanks
GVK Online Trainings-Admin Team

Fresher job Openings for 2014 Btech passed outs

Thanks
GVK Online trainings ADMIN TEAM

New MSBI batch starts from 23rd July2014

Hello Team,

We are going to start new MSBI start from 23rd July please find the below details.

Timings: 4.30-5.30AM ISD

Prerequitites :SQL Server 2012/2008R2/2008[tsql+tsql programming]

Module going to start:MSBI[SSAS]

For any queries contact us at gvkoltrainings@outlook.com

Thanks
GVKOnlineTrainings-Admin Team

UPDATE Command in SQL SERVER 2012

UPDATE:

It is used to modify the contents in the table,It is used to work with rows or records in the table.

We can update single column data or multiple columns data.Specific data  can be updated based on some condition,this condition is specified using where clause.

Syntax:

UPDATE <TABLE_NAME>
SET <COLUMN_NAME>=<EXPR/VALUE>
[WHERE CLAUSE]
SELECT * FROM EMP20

UPDATE EMP20
SET JOB='ANALYST' --will update the column job with 'ANALYST

SELECT * FROM EMP20

UPDATE EMP20
SET JOB='MANAGER'
WHERE ENO=1004 --Will update the job of employee whose number is 1004 with 'MANAGER'

SELECT * FROM EMP20

UPDATE EMP20
SET JOB='SALESMANAGER'
WHERE ENAME='VINAY' --Will update the job of employee whose name is 'VINAY' with 'MANAGER'

UPDATE EMP20
SET JOB='PROGRAMMERS'
WHERE JOB='ANALYST'--Will update the job of employee whose job is 'ANALYST' with
'PROGRAMMERS'

SELECT * FROM EMP20

Example2
CREATE TABLE STUDENT
(
SNO INT,
SNAME VARCHAR(15),
MAT INT,
PHYS INT,
CHEM INT,
TOTAL INT,
AVEG DECIMAL(4,2)
)
SELECT * FROM STUDENT

INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(101,'VINAY',50,70,80)
INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(102,'ANIL',60,90,72)
INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(103,'PAVAN',58,71,86)
INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(104,'SURESH',90,82,66)
INSERT INTO STUDENT(SNO,SNAME,MAT,PHYS,CHEM) VALUES(105,'RAMESH',85,77,73)

UPDATE STUDENT
SET TOTAL=MAT+PHYS+CHEM,
AVEG=(MAT+PHYS+CHEM)/3--'Here we are going to update the AVEG column by evaluating the expression with the help of MAT/PHY and CHEM columns.

UPDATE STUDENT
SET MAT=70
WHERE SNAME='VINAY'--'we are updating the maths marks of a student whose name is 'VINAY'
UPDATE STUDENT
SET SNAME='RAJESH'
WHERE SNO=105--'we are updating the name of a student whose student id 105

SELECT * FROM STUDENT

 **If we don't use where clause in UPDATE Command the update will reflect to all the table based on set clause.

Thanks
GSV

Identity in SQL SERVER 2012

IDENTITY:
It is used to generate unique values in sequential order.it can be called as autonumber.

If we use identity to a column there is no need of inserting values into that column. 
Syntax:

IDENTITY(<INITIAL_VALUE>/SEED,<INCREMENT>)

Example:

CREATE TABLE EMP1
(
ENO INT IDENTITY(1000,10),
ENAME VARCHAR(15)
)
Here we are specifying that eno is automatically generated when ever there is an insert is performed the eno starts with 1000 and increments with 10
INSERT INTO EMP1(ENAME) VALUES('RAMU')

SELECT * FROM EMP1

INSERT INTO EMP1(ENAME) VALUES('SRINIVAS')
INSERT INTO EMP1(ENAME) VALUES('ASHOK')
INSERT INTO EMP1(ENAME) VALUES('SURESH')

INSERT INTO EMP1(ENAME) VALUES('RAMESH')
INSERT INTO EMP1(ENAME) VALUES('RAHUL')

SELECT * FROM EMP1

DELETE FROM EMP1
WHERE ENO=1050

SELECT * FROM EMP1

INSERT INTO EMP1(ENAME) VALUES('RAHUL')

SELECT * FROM EMP1

DELETE FROM EMP1
Here we deleted all the records from emp1 table,but identity will not be reset .

SELECT * FROM EMP1

INSERT INTO EMP1(ENAME) VALUES('RAHUL')

TRUNCATE TABLE EMP1
if we use truncate identity will be reset.
SELECT * FROM EMP1

INSERT INTO EMP1(ENAME) VALUES('RAHUL')

This insert will start with seed
We can also use command to reset the identity instead of using truncate but best approach is we can reset using truncate.

Synatx:

DBCC CHECKIDENT('<TABLE_NAME>',RESEED,<INITIAL_VALUE>)

EXAMPLE:

DBCC CHECKIDENT('EMP1',RESEED,1000)

Database console check point by using this we can able to reset

INSERT INTO EMP1(ENAME) VALUES('SRINIVAS')
INSERT INTO EMP1(ENAME) VALUES('ASHOK')
INSERT INTO EMP1(ENAME) VALUES('SURESH')

INSERT INTO EMP1(ENAME) VALUES('RAMESH')

SELECT * FROM EMP1

Thanks
GSV