You are here
Home > Sql server > Sql server 2016

SQL :String Functions

String Functions In this post we will discuss String functions in SQL. SQL support many functions for String manipulations like CONCATE(), LEFT(), RIGHT() etc. In this entire post for examples we use below table. Table: persons p_id firstname lastname city 1 Amisha Patel Anand 2 Bina Patel Baroda 3 Tina Doyle v.v.nagar 4 Riya Patel Anand 5 Nikunj Patel NULL Concatenation: T-SQL support two ways for string concatenation. Concatenation using ‘+’ operator: For concatenation of string we use +

SQL: System functions

System functions In this post we will discuss System functions, it returns information about various system parameters. @@ROWCOUNT @@ROWCOUNT function returns number of rows affected by the last executed statement. It is used to check if the previous statement affects any rows by checking the function’s result is zero or greater than


OUTPUT OPTION In this post we will discuss about OUTPUT option. T-SQL supports an OUTPUT clause for modification statements, which we can use to return information from modified rows. We can use output option for purposes like auditing, archiving and others. We can use OUTPUT clause with insert, update, delete statements.

SQL: Aggregate Functions

SQL: Aggregate Functions In this post we will discuss aggregate functions. T-SQL support SUM, MIN, MAX, AVG, COUNT, SQRT, POWER and other aggregate functions. It ignores NULL inputs when applied to an expression. Use DISTINCT clause to remove duplicate values. In the group query the aggregate functions is applied per group,

SQL:Logical Functions

Logical Functions In this post we will discuss logical functions like IIF, CHOOSE, ISNUMERIC. The output of these functions are determine by comparative logic. These functions simplify migrations from Microsoft access platforms and it is nonstandard T-SQL functions. IIF() IIF() returns one of two values, depending on whether the boolean expression evaluates

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