You are here
Home > Author: Riya Patel (Page 2)

Kotlin: Enum Class

Kotlin: Enum Class In this post we will discuss Enum Class in kotlin. Enumeration is a special type of class, if class is enum type then it is limited to a set of predefined constants. To declare a class as enum use enum keyword before the class Example: enum class Direction { North,South,West,East } fun main(args:Array<String>) { var

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.

Kotlin:Data Class

Data Class In this post we will discuss Data classes with example. We frequently create a class to do nothing but hold data. Kotlin provides similar concept, called data class and marked as data. When we use data class the primary constructor only accepts property variables such as val or var

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

Kotlin Secondary Constructor

Kotlin Secondary Constructor In previous post we discussed kotlin classes and primary constructor. And in this post we will discuss how to defined secondary constructor in kotlin classes. Kotlin Secondary Constructor For declaration of secondary constructor use constructor keyword: class Employee {                        constructor(parent: Employee) { parent.children.add(this) } } If the class has a primary constructor, each secondary constructor

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