SQL Server: November 2014

Sunday, November 30, 2014

SQL Server 2014 Tutorial

Welcome to SQL Server 2014 tutorial series. This series contains basic to advance topics. You can select your topic through tutorial index.

In this tutorial series we are targeting a SQL Server beginner to an advance SQL Server user. If your a beginner keep reading this tutorial in the given sequence (It helps you to understand everything.). For advance user we divide this tutorial in various parts you can select topic as per your requirement to revise your concepts and learn new things (In case you missed something). Before start reading next post of this tutorial series please note follow below legends which helps you during your reading.
    Note: Important points to remember.
    Hint: You can press this link for important hints during solving exercise.
    Alert: Not a good practice.
    Best Practice: A best way to do something during your project, which helps you and your team to reduce your efforts in re-work.

So let’s start learning SQL Server 2014. You can contact us here (this link redirect you to our blog.vLemonn.com Contact page.) for any issues, help, support, guidance and to report any type of bug.

For any other details leave a comment we will respond to your queries ASAP.

Next: Tutorial Index

Thursday, November 27, 2014

SQL Server 2008 Interview Question

What is SQL Server TCP/IP port? How to change SQL Server port?
Difference between Clustered and non-Clustered index
Define OLTP or Explain OLTP or What is OLTP
What is Collation in SQL Server? Different types of Collation
What is difference between Primary Key and Foreign Key
What is difference between Delete and Truncate
How many ways to remove all data from a database table? Explain difference between all of them
What are properties?
What is UPDATE_STATISTICS?
Explain difference between HAVING CLAUSE and WHERE CLAUSE
What is Sub Queries? Types of sub-queries?
Explain different authentication mode in SQL Server? How to Enable or disable it ?
How to find the accurate count of a database table ?
What is Primary Key ?
What is Unique Key?
What is FOREIGN KEY?
What is CHECK Constraint ?
Explain NOT NULL Constraint ?
How to handle Error in SQL Server ?
What is SQL Server agent? How to use it ?
What is SQL Server Profiler ? How to use it ?
What is a Scheduled Tasks? How to Scheduled a Job
What is linked Server?
How to connect SQL Server with other database
What is Execution Plan? How to check Execution Plan ? When to use Execution Plan?
Types of Execution Plan? Explain difference between them?
Explain difference between Estimate Execution Plan and Actual Execution Plan
What is Log Shipping?
How to check SQL Server Version?
TSQL Command to find operating System of SQl Server
What is QUOTED_IDENTIFIER and How to use it?
How to insert data in a Identity Column
Explain temp table in SQL Server? Different types of temp table
You created a temp table in SQL Server. Where you can find this temp table?
What is Stored Procedure in SQL Server ?
Advantages of using Stored Procedures?
Difference between SQL Server Function and SQl Server Stored Procedure
What is BCP? When does it used?
What is Cardinality? How to implement it while design phase?
What is one to one, one to many and many to many relationships? How to implement in SQL Server?
What is IDENTITY INSERT? How to enable and disable Identity Insert in SQL Server
Can a user define function call itself ? If Yes how many times ?
Can a stored procedure call itself ? If Yes how many times ?
How to rename objects in SQL Server ?
Is it possible o rename SQL server database ? If yes how to rename ?
How to manipulate text in SQL Server ?
How to delete duplicate records from SQL Server database table?
What is GO command ?
What is Dynamic SQL Command ? How to create dynamic SQL Command and Execute It?
What is Synonyms in SQL Server?

SQL Server 2012 Interview Question

What is SQL Server TCP/IP port? How to change SQL Server port?
Difference between Clustered and non-Clustered index
Define OLTP or Explain OLTP or What is OLTP
What is Collation in SQL Server? Different types of Collation
What is difference between Primary Key and Foreign Key
What is difference between Delete and Truncate
How many ways to remove all data from a database table? Explain difference between all of them
What are properties?
What is UPDATE_STATISTICS?
Explain difference between HAVING CLAUSE and WHERE CLAUSE
What is Sub Queries? Types of sub-queries?
Explain different authentication mode in SQL Server? How to Enable or disable it ?
How to find the accurate count of a database table ?
What is Primary Key ?
What is Unique Key?
What is FOREIGN KEY?
What is CHECK Constraint ?
Explain NOT NULL Constraint ?
How to handle Error in SQL Server ?
What is SQL Server agent? How to use it ?
What is SQL Server Profiler ? How to use it ?
What is a Scheduled Tasks? How to Scheduled a Job
What is linked Server?
How to connect SQL Server with other database
What is Execution Plan? How to check Execution Plan ? When to use Execution Plan?
Types of Execution Plan? Explain difference between them?
Explain difference between Estimate Execution Plan and Actual Execution Plan
What is Log Shipping?
How to check SQL Server Version?
TSQL Command to find operating System of SQl Server
What is QUOTED_IDENTIFIER and How to use it?
How to insert data in a Identity Column
Explain temp table in SQL Server? Different types of temp table
You created a temp table in SQL Server. Where you can find this temp table?
What is Stored Procedure in SQL Server ?
Advantages of using Stored Procedures?
Difference between SQL Server Function and SQl Server Stored Procedure
What is BCP? When does it used?
What is Cardinality? How to implement it while design phase?
What is one to one, one to many and many to many relationships? How to implement in SQL Server?
What is IDENTITY INSERT? How to enable and disable Identity Insert in SQL Server
Can a user define function call itself ? If Yes how many times ?
Can a stored procedure call itself ? If Yes how many times ?
How to rename objects in SQL Server ?
Is it possible o rename SQL server database ? If yes how to rename ?
How to manipulate text in SQL Server ?
How to delete duplicate records from SQL Server database table?
What is GO command ?
What is Dynamic SQL Command ? How to create dynamic SQL Command and Execute It?
What is Synonyms in SQL Server?

SQL Server 2014 Interview Question

What is SQL Server TCP/IP port? How to change SQL Server port?
Difference between Clustered and non-Clustered index
Define OLTP or Explain OLTP or What is OLTP
What is Collation in SQL Server? Different types of Collation
What is difference between Primary Key and Foreign Key
What is difference between Delete and Truncate
How many ways to remove all data from a database table? Explain difference between all of them
What are properties?
What is UPDATE_STATISTICS?
Explain difference between HAVING CLAUSE and WHERE CLAUSE
What is Sub Queries? Types of sub-queries?
Explain different authentication mode in SQL Server? How to Enable or disable it ?
How to find the accurate count of a database table ?
What is Primary Key ?
What is Unique Key?
What is FOREIGN KEY?
What is CHECK Constraint ?
Explain NOT NULL Constraint ?
How to handle Error in SQL Server ?
What is SQL Server agent? How to use it ?
What is SQL Server Profiler ? How to use it ?
What is a Scheduled Tasks? How to Scheduled a Job
What is linked Server?
How to connect SQL Server with other database
What is Execution Plan? How to check Execution Plan ? When to use Execution Plan?
Types of Execution Plan? Explain difference between them?
Explain difference between Estimate Execution Plan and Actual Execution Plan
What is Log Shipping?
How to check SQL Server Version?
TSQL Command to find operating System of SQl Server
What is QUOTED_IDENTIFIER and How to use it?
How to insert data in a Identity Column
Explain temp table in SQL Server? Different types of temp table
You created a temp table in SQL Server. Where you can find this temp table?
What is Stored Procedure in SQL Server ?
Advantages of using Stored Procedures?
Difference between SQL Server Function and SQl Server Stored Procedure
What is BCP? When does it used?
What is Cardinality? How to implement it while design phase?
What is one to one, one to many and many to many relationships? How to implement in SQL Server?
What is IDENTITY INSERT? How to enable and disable Identity Insert in SQL Server
Can a user define function call itself ? If Yes how many times ?
Can a stored procedure call itself ? If Yes how many times ?
How to rename objects in SQL Server ?
Is it possible o rename SQL server database ? If yes how to rename ?
How to manipulate text in SQL Server ?
How to delete duplicate records from SQL Server database table?
What is GO command ?
What is Dynamic SQL Command ? How to create dynamic SQL Command and Execute It?
What is Synonyms in SQL Server?

SQL Server Interview Question

What is SQL Server TCP/IP port? How to change SQL Server port?
Difference between Clustered and non-Clustered index
Define OLTP or Explain OLTP or What is OLTP
What is Collation in SQL Server? Different types of Collation
What is difference between Primary Key and Foreign Key
What is difference between Delete and Truncate
How many ways to remove all data from a database table? Explain difference between all of them
What are properties?
What is UPDATE_STATISTICS?
Explain difference between HAVING CLAUSE and WHERE CLAUSE
What is Sub Queries? Types of sub-queries?
Explain different authentication mode in SQL Server? How to Enable or disable it ?
How to find the accurate count of a database table ?
What is Primary Key ?
What is Unique Key?
What is FOREIGN KEY?
What is CHECK Constraint ?
Explain NOT NULL Constraint ?
How to handle Error in SQL Server ?
What is SQL Server agent? How to use it ?
What is SQL Server Profiler ? How to use it ?
What is a Scheduled Tasks? How to Scheduled a Job
What is linked Server?
How to connect SQL Server with other database
What is Execution Plan? How to check Execution Plan ? When to use Execution Plan?
Types of Execution Plan? Explain difference between them?
Explain difference between Estimate Execution Plan and Actual Execution Plan
What is Log Shipping?
How to check SQL Server Version?
TSQL Command to find operating System of SQl Server
What is QUOTED_IDENTIFIER and How to use it?
How to insert data in a Identity Column
Explain temp table in SQL Server? Different types of temp table
You created a temp table in SQL Server. Where you can find this temp table?
What is Stored Procedure in SQL Server ?
Advantages of using Stored Procedures?
Difference between SQL Server Function and SQl Server Stored Procedure
What is BCP? When does it used?
What is Cardinality? How to implement it while design phase?
What is one to one, one to many and many to many relationships? How to implement in SQL Server?
What is IDENTITY INSERT? How to enable and disable Identity Insert in SQL Server
Can a user define function call itself ? If Yes how many times ?
Can a stored procedure call itself ? If Yes how many times ?
How to rename objects in SQL Server ?
Is it possible o rename SQL server database ? If yes how to rename ?
How to manipulate text in SQL Server ?
How to delete duplicate records from SQL Server database table?
What is GO command ?
What is Dynamic SQL Command ? How to create dynamic SQL Command and Execute It?
What is Synonyms in SQL Server?

Tuesday, November 11, 2014

SQL Server SELECT Literal

SQL Server SELECT

SELECT statement is used to retrive data from database. In thus post we are going to execute our first SELECT statement 'Hello World!!! '.

Before going further we assume you have initial setup for this exercise. If not we recommend to read below post.

Install SQL Server
Open SQL Server Management Studio.
Connect to SQL Server and Open new query window. Execute a test query.
Add sample database.

We assume you opened SSMS, and query window is opened.

In your opened query window execute below command

SELECT 'Hello World!!! ';

Output

What happened here in this example We use SELECT statement to retrive data from literal. So what is literal?Literals are strings are number.

What we learn from this

SELECT statement is used to retrive data from different database objects such as database table or literals. So if you are thinking SELECT statement is used only to bring data from database take than it is wrong.

Below are some more example of SELECT statement with literals.

SELECT 1947;

SELECT 'Hello'+'1';

Now I suggest keep practicing with literals and share your experience with me.

In our next post we are going to use SELECT statement with a database table

Data Manipulation Language

Data Manipulation Language (DML) is used to retrive, modify, and store data in a database.

Following are the Example of DML statements

SELECT: It is used to retrive data from database. Read more about SELECT.
INSERT
UPDATE
DELETE

In our next post we are going to use SELECT statement.

Monday, November 10, 2014

TSQL Introduction

Structured Query Language (SQL) is used for managing relational database management system.It is developed at IBM in 1970s by Donald D. Chamberlin and Raymond F. Boyce. Currently it is used in various databases such as Oracle, Microsoft SQL Server,My SQL, IBM DB2, Sybase, Teradata,Access etc.
TSQL or Transact SQL is commercial version of SQL developed by Microsoft to manage SQL Server database.

The TSQL is mainly divide in three sections, data manipulation language (DML), data definition language (DDL), and data control language ( DCL). In this blog we are going to show all the sections in details.

In our next post we are going to learn about DML.