Rohit Dhand

Hi Students, Planning to start new courses on: 1. Ruby on Rails. 2. Node.js 3. ASP.NET MVC 4. SQL Server 2016 5. ReactJS 6. AngularJS in the Online mode with the help of Skype. This is being done after the successful finishing of couple of batches through the same mode. Interested students may contact me for more details on: dhandrohit@gmail.com Happy Coding!.

If we are encountering an error in the creation of the steps in the Job Creation under SQL Server 2008 R2, then we need to apply a hotfix available from Microsoft. Download the hotfix from the following site: https://support.microsoft.com/en-ca/kb/2261464 The Error is like "Component with ClassID ClsID Not found"

There is only one command to retrieve data back from the table and it is known as “Select”. Select can be used with different operators. Following are the different formats of Select command that can be used: Ø   Select * from Dept To Select all columns and all rows from Dept table Ø   Select Deptno , Dname from Dept To Select Column Deptno and Dname from Dept table Ø   Select Deptno * 10 as 'Calculated Deptno' from Dept This will multiply Deptno with 10 and the name of the column displayed will be ‘Calculated Deptno’ Ø   Select * from Dept where Deptno = 10 To select all rows where Deptno is equal to 10 Other Examples of Select Query Ø   Select * from Dept where Dname = 'MARKETING' Ø   Select * from Dept where Deptno = 10 or Loc = 'BOSTON' Ø   Select * from Dept where Deptno = 10 and LOC = 'BOSTON' Ø   Select * from Dept where Deptno between 10 and 30 Ø ...

SQLSERVER_9: Insert, Delete and Update Command Insert, Delete and Update commands are the Data Manipulation Commands in SQL Server. a.      Insert Insert command is used to create new records / rows in the Table. The following command is a basic example of Insert Command. Ø   Insert into Emp ( Empno , Ename ) values ( 101 , 'ABC' ) The above command inserts into table named “Emp” and in columns “Empno”, “Ename” with values 101 and ABC. The above command has following advantages: a.       We can skip any column in which we don’t want to insert any data. b.      We can also change the order of columns. The another type of insert command: Ø   Insert into Emp values ( 101 , 'ABC' ) In the above command, we cannot change the Column Order and even we can’t skip any column value. b.      Update Update command is used to update existing values...

Sometimes we forget to include constraints while a table is created. So SQL Server provides mechanism to include constraints in an already existing table. The following commands shows how to do the same: Alter table EmpTemp add constraint Salary_check check ( salary between 1000 and 5000 ) In the above command we are adding a constraint “Salary_check” on table “EmpTemp” and on column “Salary” i.e. its value between 1000 and 5000 only. Below are some commands to add constraints to an existing table. 1.   Alter table temp1 add Constraint Salary_check unique ( salary ) 2.   Alter table temp1 add constraint salary_primary primary key ( salary ) 3.   Alter table temp1 add constraint fk_dept foreign key ( Deptno ) references dept ( deptno )

In the real world, we have to use constraints that are not only dependent upon one table rather on two tables. This kind of setup is known as Primary Key - Foreign key constraint or also known as “Referential Integrity”. For e.g. lets see the example below: a.     Dept Table b.     Emp Table In order to determine the relationship, we have taken a column “Deptno” in Emp table which is validated from “Dept” table. It means “Emp” table’s column Deptno is having all the values from the Dept table and it cannot have a value that is not there in the Dept Table. To define the foreign key constraint, we can use the following syntax: FOREIGN KEY / REFRENTIAL INTEGRITY Create Table EmpTemp1 ( deptno numeric ( 10 ) constraint fk references dept ( deptno ) )

Constraints or validations are a well known phenomenon in and Database Management system to ensure that the columns can receive values that are well within the limit and restrictions imposed. For e.g. we can impose a check on a column named “Age” that the value should be between 20 – 40 only. This can be achieved by the following constraint Create Table EmpTemp ( Age numeric ( 10 ) constraint age_check check ( age between 20 and 40 ) ) There are different kinds of constraints in SQL Server: A    PRIMARY KEY CONSTRAINT This constraint is to ensure that we can differentiate between two rows in a table. There can only be one primary key in a table and it cannot be null and it will not allow duplicate values. Create Table EmpTemp (       Code numeric ( 10 ) constraint pk_primary primary key ) B.    UNIQUE This constraint is to ensure that we are not going to insert a duplicate value. Crea...

SQL Server provides Alter and Drop commands for dropping tables and Database, as well changing the structure of Table. i.                    Drop This command is used to drop the Table or Database. We can use the command is the following way: Drop Table Dept      - This command will drop the table named “DEPT” Drop Database Test   - This command will drop the database named “TEST” ii.                  Alter This command is used to alter the Structure of Table. We can add, remove columns or even constraints with the help of this command. Alter table emptemp add address varchar ( 20 ) The above command will add a new column named “address” in the table called “emptemp” Alter table emptemp drop column address The above command will delete ...

The basic building block of storing data in SQL Server Database is a “Table” aka “Relation”. It’s a collection of rows and columns grouped together. Ø   Rows in a table are aka Tuples, Records. Ø   Columns in a table are aka Fields, Attributes, Columns. The following figure clearly explains the terminology: We can see that the above figure represents a Relation / Table named “DEPT” and it has got fields like “Deptno”, “Dname” etc. The following command is used to create a table: Create Table Dept (      Deptno numeric ( 10 ),      Dname varchar ( 100 ),      Loc varchar ( 100 ) ) We are creating a table with 3 columns. And two columns have “varchar” datatype and Deptno has got “numeric” datatype. DataType means what kind of Data we can store in that field. Numeric as name suggests can store numbers and Varchar can store alphanumeric. We will have more on DataTypes in th...

Creating User Defined Databases in SQL Server. As a user we can create a User Defined Database in SQL Server. This database can store tables, views, stored procedures, functions etc. Every database has got two files: a.      MDF File This is the main data file in which data is stored. b.      LDF File LDF primarily stores all the logs. Logs are nothing but recording of every activity going in the database like inserting, deleting, updating etc. for the purpose of backup and retrieval. The following command can be used to create a Database in SQL Server Management Studio. USE [master] GO CREATE DATABASE Test        On Primary     (               NAME = N'Test' , FILENAME = N'C:\Temp\Test.mdf' ,               SIZE = 167872 K...

System Databases SQL Server comes with certain System Databases, that get installed by default. All the System Databases has some specific purpose and they primarily maintain META Data i.e. Data about Data.   a.       Master This is a System Database that is primarily used to store information about the user data. For e.g. if we create a table, then information about its primary key, how many columns, data types etc. is maintained in this database. b.      Model This is a template database that is used whenever we create a new Database. This will help in laying the basic structure of our new database. c.       TempDB This is also known as Temporary Database. SQL Server uses TempDB for storing temporary data while doing different operations. d.      MSDB The msdb database is used by SQL Server Agent for scheduling alerts and jobs. Will ...

SQLSERVER_1: What is SQL Server? SQL Server is a RDBMS (Relational Database Management System) from Microsoft. It supports T-Structured Query Language (Transact -SQL) and PL/SQL. Recently Microsoft has made lot of improvements in this product by introducing Business Intelligence, Reporting Services, etc. SQL Server primarily constitutes: a. T-SQL and PL/SQL b. Reporting Services. c. SSIS - SQL Server Integration Services. d. SSAS- SQL Server Analysis Services. Microsoft SQL Server is one of the RDBMS in the market besides Oracle, MySQL, PostGRE etc. Current Version of SQL Server is 2016. And it comes in different Editions.

On popular requests from my dear students, I am going to post stuff about Databases and that too on SQL Server. All my next posts will focus on the basics of the SQL Server, its working, SQL and PL/SQL etc. Enjoy all the posts and in case you want to have posts on specific topics, please share at dhandrohit@gmail.com

You can change the Boot Order of Microsoft Surface Pro 3 and above, use the following sequence of commands: Step 1: Shut down your Surface. Step 2: Once Surface has turned off, press and hold the volume-up button. Step 3: With the volume-up button held down, press and release the power button. Step 4: Continue holding the volume-up button until the Surface logo no longer appears on the screen. You should now see the Surface UEFI. Do one of the following: Surface Pro 3 and Surface 3:  Go to  Step 5  below. Surface Pro 1 and Surface Pro 2:  Skip to  Step 9  below. Surface Pro 3 and Surface 3: Step 5: Select  Configure Alternate System Boot Order . Step 6: Do one of the following: Surface Pro 3:  Select  USB  >  SSD Surface 3:  Select  Network  >  USB  >  SSD . Step 7: Select  Exit Setup . Step 8: Select  Yes  to save the configuration and restart Surface. ...