You are here
Home > Sql server > Sql server 2016 (Page 2)

SQL 70-761 Quiz

Welcome to SQL quiz. we have list of questions and there is no time limit for giving the answer. this quiz improve your SQL and database knowledge.We have divided SQL quiz into three parts. Keep Visiting for more upcoming top technical articles and also see my new blog Mag4info. and for kotlin tutorial also

Deterministic & Non-deterministic Functions

Deterministic & Non-deterministic Functions In this post we will discuss about Function determinism. Function can be deterministic or non-deterministic. Function determinism is a characteristic that indicates whether the function is guaranteed to return the same result given the same set of input values in different invocations. If the function provides such

SQL: Case Expression

CASE EXPRESSION In this post we will discuss CASE statement. This statement performs some kind of an action or controls the flow of the code. The CASE expression has two forms- the simple form and the searched form. CASE returns a value, and hence is an expression. Simple CASE The simple form

SQL: Logical Query Processing Phases

Logical Query Processing Phases In this post we will discuss logical query processing phases in SQL server. Logical query processing means in which order the sql query clause is evaluated. The below table represent the order of clause evaluation in SQL: Evaluation No SQL clause 1 From (join, pivot, unpivot, apply) 2 Where (predicate) 3 Group by (grouping sets,


ALTER COMMAND In this post we will discuss about ALTER command it is useful when we have created a table and after we have to add or delete something from the table structure. ALTER command is used to modify the structure of the exiting table. Using ALTER command, it is possible

Handling NULL values in SQL

Handling NULL values in SQL In this post we learn how to handle NULLs in SQL server. for handling NULLs in SQL server we use ISNULL(), NULLIF(), COALESCE() functions with example. ISNULL(): The ISNULL() function is commonly used function that return first value that is not null among their input. Syntax: ISNULL(col_name, replacement_value) The