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 […]
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
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
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
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
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
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
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 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 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’
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
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
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
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