Happy Diwali
Wish you all a very happy and blessed festive season. May this festival of lights brings more brightness in your […]
Boyce – Codd Normal Form (BCNF)
Boyce – Codd Normal Form (BCNF) :- A normal form is said to be a Boyce – Codd Normal Form if
Isolation levels in SQL Server
Isolation levels :- Isolation level is required to isolate a resource and protect it from other transactions. This is achieved
Merge Command In Sql Server
Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and
Adding , Deleting and Updating a Column in a table
Many times we need to alter the table definition by adding , deleting or updating a column in the table.
Adding , Deleting and Updating a Column in a table Read Post »
Derived Table In Sql Server
Derived tables:- Derived tables are the tables which are created on the fly with the help of the Select statement. It
Pivot and Unpivot table in SQL SERVER
Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means
SQL Server- Output clause
Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the
CTE command In Sql Server
Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by
SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we
SQL Server – Local temporary table
Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user’s session
SQL Server – Global temporary tables
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as well. Global
SQL Basic Concepts, SQL Server
How to rename a Table in Sql Server
To rename a column in a SQL Table following command can be reused: SP_RENAME ‘old table name’, ‘New table name’
SQL Basic Concepts, SQL Server
How to change the database collation
To change the collation of an database following commands can be used: ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE [database name] COLLATE Newcollation ALTER DATABASE [database name] SET MULTI_USER For example
SQL Server Functions- An Introduction
SQL FUNCTION: – Function in a database can be defined as the code segment consisting of a logical group of