IN clause in SQL Server
With IN clause, we can specify multiple values in a WHERE clause. For example, in case of “IN”, one can […]
IN clause in SQL Server Read Post »
SQL Basic Concepts
SQL Basic Concepts
AND and OR Operator in Sql Server
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one
AND and OR Operator in Sql Server Read Post »
Except command in SQL Server
Except command in SQL Server returns the distinct values from the left query that are not also found on the
Except command in SQL Server Read Post »
Intersection command in SQL Server
This function is used to returns distinct values that are returned by both the query on the left and right
Intersection command in SQL Server Read Post »
While loop in SQL server
While loop in SQL server Introduction In While loop, we set a condition for the repeated execution of a Code
While loop in SQL server Read Post »
Stuff VS Replace function in SQL Server
Stuff VS Replace function Stuff Function This function is used to replace string from the given start position, passed as
Stuff VS Replace function in SQL Server Read Post »
Case Statement/ Expression in SQL Server
Case Statement/ Expression in SQL server Sometimes we need to get one result output from multiple possible outcomes based on
Case Statement/ Expression in SQL Server Read Post »
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 »
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-Table Variable Read Post »
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
How to change the database collation Read Post »
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’
How to rename a Table in Sql Server Read Post »
Renaming a column in Sql Server
We often need to change the name of a column of a table to a new name. We can do
Renaming a column in Sql Server Read Post »
Interview Questions, SQL Basic Concepts, SQL Server
How to find duplicate values in a table
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a
How to find duplicate values in a table Read Post »
Difference between Delete and Truncate Command
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still
Difference between Delete and Truncate Command Read Post »
SQL Basic Concepts, SQL Server
IDENTITY Property in SQL Server
IDENTITY Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve
IDENTITY Property in SQL Server Read Post »
SQL Basic Concepts, SQL Server
How to make database offline or online
Database is made offline to move its physical files. There can be many ways to make a database offline. But
How to make database offline or online Read Post »
SQL Basic Concepts, SQL Server
Different ways to create a table and insert data into the table
Introduction Tables can be defined as the structure which contains the data in the database. This article discuss about the
Different ways to create a table and insert data into the table Read Post »
You must be logged in to post a comment.