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
Continue reading
Category: 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
Share this:
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
Share this:
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
Share this:
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
Share this:
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
Share this:
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
Share this:
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.
Share this:
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
Share this:
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
