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…
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.…
SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar…
How to change the database collation
To change the collation of an database following commands can be used: ALTER DATABASE SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER…