MS SQL Server Interview point of view concepts – Part 1

 

Connecting to SQL Server using SSMS - Part 1

 

 

 

 

 

 

 

 

 

 

 

 

 

Creating altering and dropping a database

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Creating and working with tables

 

 

 

 

 

 

Relationship via GUI

 

 

 

 

 

 

 

Relationship via Query

 

 

 

 

 

Adding a default constraint

 

 

 

 

 

 

 

 

 

 

 

 

Cascading referential integrity constraint

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Adding a check constraint

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Identity Column in SQL Server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

How to get the last generated identity column value in SQL Server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Unique key constraint

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Select statement in sql server

 

 

 

 

 

 

 

 

 

 

 

ote: when we use distinct on more than one columns, that means it will be performed distinct on across the columns.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Group by in sql server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Joins in sql server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Advanced or intelligent joins in sql server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Self join in sql server

 

 

 

 

 

 

 

 

Different ways to replace NULL in sql server

 

 

 

 

 

 

 

 

 

 

 

Coalesce function in sql server

 

 

 

 

 

 

 

 

 

Union and union all in sql server

 

 

 

 

 

 

 

 

 

 

 

Stored procedures in sql server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Stored procedures with output parameters

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Stored procedure output parameters or return values

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Note: If you use RETRUN keyword in stored procedure, it should be always integer.  AS well as, it will return only one value.

 

 

 

 

Advantages of stored procedures

 

 

 

 

 

Built in string functions in sql server 2008

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server

 

 

 

 

 

 

 

 

 

 

 

 

Replicate, Space, Patindex, Replace and Stuff string functions in sql server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

DateTime functions in SQL Server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

IsDate, Day, Month, Year and DateName DateTime functions in SQL Server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

DatePart, DateAdd and DateDiff functions in SQL Server

 

 

 

 

 

 

 

 

Cast and Convert functions in SQL Server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Mathematical functions in sql server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Scalar user defined functions in sql server

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Inline table valued functions

 

 

 

 

 

 

 

 

 

 

 

 

Multi statement table valued functions in sql server

 

 

 

 

 

 

 

 

 

 

Important concepts related to functions in sql server

 

 

 

Blogger Labels: Server,Tutorial,Beginners,SSMS,Part,database,Relationship,Query,constraint,Column,Unique,Select,statement,columns,Group,Joins,Self,Different,NULL,Coalesce,Union,procedures,output,parameters,procedure,Note,RETRUN,integer,Advantages,Built,LEFT,CHARINDEX,Replicate,Space,Patindex,Replace,Stuff,DateTime,IsDate,Month,DateName,DatePart,DateAdd,DateDiff,Cast,Convert,Mathematical,Scalar,user,Inline,Multi,Important,concepts