date and time functions
Sql server 2016

SQL : Date and Time Functions

Date and Time Functions In this post we will discuss date and time functions in SQL server 2016. SQL support many date and time functions that are used to manipulate
date and time functions
Sql server 2016

SQL: Date and Time Functions

Date and Time Functions In this post we will discuss date and time functions in SQL server 2016. SQL support many date and time functions that are used to manipulate
Enum Class
Kotlin

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
system function
Sql server 2016

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.
OUTPUT option
Sql server 2016

SQL:OUTPUT OPTION

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
Data classes
Kotlin

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
aggregate functions
Sql server 2016

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
Logical Functions
Sql server 2016

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
Class delegation and Sealed Classes
Kotlin

Kotlin: Class delegation & Sealed Classes

Kotlin: Class delegation & Sealed Classes In this post we will discuss class delegation and sealed classes in kotlin. Class delegation A delegate is a reference type variable that holds
SQL quiz
Sql server 2016

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
Top