Tutorial by Examples: d

SELECT SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ProductLevel') AS ProductLevel, SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('EngineEdition') AS EngineEdition;

SELECT DATEDIFF(DAY, login_time, getdate()) UpDays FROM master..sysprocesses WHERE spid = 1

Since a Vimscript file is a collection of Command mode actions, the user needs to specify that the desired actions should be executed in normal mode. Therefore executing a normal mode command like i, a, d etc. in Vimscript is done by prepending the command with normal: Going to the bottom of the f...

If you are running a command that returns hundreds of lines, but your interest is just on the lines that contains the word <word>, you should definitely use grep! For example try running: ifconfig -a Check the output, that could be only a few lines or quite long, if you have a server with ...

You can create and configure build types in the module-level build.gradle file inside the android {} block. android { ... defaultConfig {...} buildTypes { release { minifyEnabled true proguardFiles getDefaultProguar...

See discussions in "GRANT" and "Recovering root password".

1067 This is probably related to TIMESTAMP defaults, which have changed over time. See TIMESTAMP defaults in the Dates & Times page. (which does not exist yet) 1292/1366 DOUBLE/Integer Check for letters or other syntax errors. Check that the columns align; perhaps you think you are putting i...

In some cases basic validation is not enough. Angular support custom validation adding validator functions to the $validators object on the ngModelController: angular.module('app', []) .directive('myValidator', function() { return { // element must have ng-model attribute // o...

It may be helpful to include additional information with an exception, e.g. for logging purposes or to allow conditional handling when the exception is caught: class CustomError < StandardError attr_reader :safe_to_retry def initialize(safe_to_retry = false, message = 'Something went wro...

English text has the occasional diacritics. Loan words, like née, café, entrée Names, like Noël and Chloë Place names, like Montréal and Québec

If you want to set some alias name to installed node version, do: nvm alias <name> <version> Similary to unalias, do: nvm unalias <name> A proper usecase would be, if you want to set some other version than stable version as default alias. default aliased versions are loade...

In this example we create a new list element with the text "new text", and select the first unordered list, and its first list element. let newElement = document.createElement("li"); newElement.innerHTML = "new text"; let parentElement = document.querySelector(&quo...

There are several ways of getting the data that you will bind to the DOM elements. The simpler one is having your data in your script as an array... var data = [ ... ]; But D3.js allows us to load data from an external file. In this example, we will see how to properly load and deal with data fr...

You can allow role to access some action on resource by: $acl->allow('Administrator', 'products', 'create'); You can deny role to access some action on resource by: $acl->deny('Customer', 'categories', 'create'); You can check if role is allowed to some action on resource by using: $a...

You can add also add some more logic which has to be checked to your ACL using anonymous functions. They will be executed when using Phalcon\Acl\Adapter\Memory::allow() or Phalcon\Acl\Adapter\Memory::deny(), if they will return true, they role will be allowed to access certain action on resource. $...

By implementing Phalcon\Acl\RoleAware or Phalcon\Acl\ResourceAware you can use them as objects in Phalcon\Acl\Adapter\Memory::isAllowed(). // Create our class which will be used as roleName class UserRole implements Phalcon\Acl\RoleAware { protected $id; protected $roleName; publ...

Modifying the strings returned by the standard functions getenv(), strerror() and setlocale() is undefined. So, implementations may use static storage for these strings. The getenv() function, C11, §7.22.4.7, 4, says: The getenv function returns a pointer to a string associated with the matched...

To execute a function within a loop in node.js, it's fine to use a for loop for short loops. But the loop is long, using for loop will increase the time of processing which might cause the node process to hang. In such scenarios, you can use: asycn.times function recursiveAction(n, callback) { ...

When we want to handle array of data, its better to use async.each. When we want to perform something with all data & want to get the final callback once everything is done, then this method will be useful. This is handled in parallel way. function createUser(userName, callback) { //creat...

var path = "/test_javascript_upload.txt"; var content = "data to upload"; var accessToken = "<ACCESS_TOKEN>"; var uploadUrl = "https://content.dropboxapi.com/2/files/upload" var result; var xhr = new XMLHttpRequest(); xhr.onreadystatechange = fun...