How do you choose columns to create indexes in a table?

We should create indexes on the columns which are, Mostly used in WHERE clause Mostly used in JOIN conditions Mostly used in Order by If we are creating a concatenated index on more than one column, give first preference to the column

Read More

Assignment Operator

The name itself is saying that, it assigns values to the variables or fields of a table. We have only one assignment operator ‘=’ in SQL Server. It plays a key role while writing queries. We cannot write complex queries without Assignment

Read More