SQL AND & OR Operators
SQL AND operator is used to filter the records by combining two boolean expressions and returns true when both boolean expressions are true whereas SQL OR operator returns true value when either the first...
SQLServerLog.com - Database Tips, Techniques and Tutorials
SQL IN Operator
You can specify multiple values with IN operator and it will return matching values from WHERE clause of a table. IN operator matches values in a list or subquery and returns the output. Here...
SQL GROUP BY Clause
The GROUP BY clause is used to summarize data based on grouping criteria. For each group one column is returned in result set. Syntax SELECT expression1, expression2, … expressionN, aggregate_function (aggregate_expression) FROM TableName WHERE conditions GROUP...
Fixed Server Roles in SQL Server
442viewsTo maintain security and access level of database, SQL Server provides fixed server roles. As the name indicates, you cannot modify or alter server roles hence it helps to manage permissions on the server....
SQL CREATE TABLE Statement
A table is primarily a list of useful items or a group of lists and to manage such list it should be organised. To organise this information it is divided into rows and columns....
IIF() Logical Function in SQL Server
IIF() logical function has been introduced in SQL Server 2012. We already know about CASE expression and IF-Else statement in SQL Server so now you can also use IIF() function to get the same output in...
