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
With IN clause, we can specify multiple values in a WHERE clause. For example, in case of “IN”, one can […]
And & Or:- These Operators are used to further filter the recordset return by SQL queries when more than one
Except command in SQL Server returns the distinct values from the left query that are not also found on the
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 Introduction In While loop, we set a condition for the repeated execution of a Code
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 Sometimes we need to get one result output from multiple possible outcomes based on
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 »
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we
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
To rename a column in a SQL Table following command can be reused: SP_RENAME ‘old table name’, ‘New table name’
We often need to change the name of a column of a table to a new name. We can do
Sometimes duplicate values in tables can create a major problem when we do not make a primary key or a
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still
IDENTITY Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve