Tutorial by Topics: es

EOMONTH (start_date [, month_to_add ] ) as per https://msdn.microsoft.com/en-us/library/ms187819.aspx, DateTimes are only precise to 3ms. Rounding of datetime Fractional Second Precision datetime values are rounded to increments of .000, .003, or .007 seconds, as shown in the following ta...

ParameterDescriptionStableYesIn placeYesBest case complexityO(n)Average case complexityO(n^2)Worst case complexityO(n^2)Space complexityO(1)

Visual Basic 14 is the version of Visual Basic that was shipped as part of Visual Studio 2015. This version was rewritten from scratch in about 1.3 million lines of VB. Many features were added to remove common irritations and to make common coding patterns cleaner. The version number of Visual Ba...

Set - The operator used to set a reference to an object, such as a Range For Each - The operator used to loop through every item in a collection Note that the variable names r, cell and others can be named however you like but should be named appropriately so the code is easier to underst...

These classes are reference libraries of methods and properties that do not change state, in one word, immutable. You don't need to create them, you simply use them. Classes and methods such as these are called static classes because they are not created, destroyed, or changed.You can refer to a sta...

AVSpeechSynthesizer() // Creates a speech synthesiser speaker.speakUtterance(speech) // Converts the text to speech ParameterDetailsspeakerAVSpeechSynthesizer objectspeechAVSpeechUtterance object

import {component} from 'libName'; // Will import the class "component" import {component as c} from 'libName'; // Will import the class "component" into a "c" object import component from 'libname'; // Will import the default export from libName import * as lib fr...

This code will turn off the capability for a user to hold down the Shift key when opening a database to skip the default form opening and allow the user access to the Navigation Pane and VB Editor. In DB’s that you do not want users to have access to either of these (along with disabling the use ...

As database tables grow, it's often useful to limit the results of queries to a fixed number or percentage. This can be achieved using SQL Server's TOP keyword or OFFSET FETCH clause. ParameterDetailsTOPLimiting keyword. Use with a number.PERCENTPercentage keyword. Comes after TOP and limiting ...

TypeScript, like ECMA Script 6, support object-oriented programming using classes. This contrasts with older JavaScript versions, which only supported prototype-based inheritance chain. The class support in TypeScript is similar to that of languages like Java and C#, in that classes may inherit fro...

my # Lexical declaration our # Global declaration $foo # Scalar @foo # Array $#foo # Array Last-Index %foo # Hash ${$foo} # Scalar De-Reference @{$foo} # Array De-Reference $#{$foo} # Array-DeRef Last-Index %{$foo} # Hash De-Reference $foo[$index] # Array get indexed ${$foo}[$inde...

To select rows with out duplicates change the WHERE clause to "RowCnt = 1" To select one row from each set use Rank() instead of Sum() and change the outer WHERE clause to select rows with Rank() = 1