Tutorial by Examples: a

GRANT SELECT ON [dbo].[someTable] TO [aUser]; REVOKE SELECT ON [dbo].[someTable] TO [aUser]; --REVOKE SELECT [dbo].[someTable] FROM [aUser]; is equivalent DENY SELECT ON [dbo].[someTable] TO [aUser];

--implicitly map this user to a login of the same name as the user CREATE USER [aUser]; --explicitly mapping what login the user should be associated with CREATE USER [aUser] FOR LOGIN [aUser];

CREATE ROLE [myRole];

-- SQL 2005+ exec sp_addrolemember @rolename = 'myRole', @membername = 'aUser'; exec sp_droprolemember @rolename = 'myRole', @membername = 'aUser'; -- SQL 2008+ ALTER ROLE [myRole] ADD MEMBER [aUser]; ALTER ROLE [myRole] DROP MEMBER [aUser]; Note: role members can be any database-level pri...

In this example we have a service, let's call it search service that has a method called search() which will initiate a get request to a back end API. function SearchService($http) { const service = {}; service.search = function() { return $http({method: 'GET', url: `/api/s...

function calculatorService() { const service = {}; service.add = function(a,b) { return a + b } return service; } angular.module('app').factory('calculatorService', calculatorService); Testing describe('calculator service', function() { var calcula...

Files compressed by gzip can be directly concatenated into larger gzipped files. cat file1.gz file2.gz file3.gz > combined.gz This is a property of gzip that is less efficient than concatenating the input files and gzipping the result: cat file1 file2 file3 | gzip > combined.gz A compl...

The easiest way is to use pip and VirtualEnv. Selenium also requires python 3.*. Install virtualenv using: $: pip install virtualenv Create/enter a directory for your Selenium files: $: cd my_selenium_project Create a new VirtualEnv in the directory for your Selenium files: $: virtualenv -...

Unity layers are similar to tags as in that they can be used to define objects that should be interacted with or should behave in a certain manner, however, layers are mainly used with functions in the Physics class: Unity Documentation - Physics Layers are represented by an integer and can be pass...

The LayerMask structure is an interface that functions almost exactly like passing an integer to the function in question. However, its biggest benefit is allowing the user to select the layer in question from a drop-down menu in the inspector. using UnityEngine; class LayerMaskExample{ pub...

This examples shows how to build a JavaFX application, where the language can be switched dynamically while the application is running. These are the message bundle files used in the example: messages_en.properties: window.title=Dynamic language change button.english=English button.german=Germa...

from selenium import webdriver # Create a new cromedriver driver = webdriver.Chrome() # Go to www.google.com driver.get("https://www.google.com") # Saves a .png file with name my_screenshot_name to the directory that # you are running the program from. screenshot_name = "my_s...

Install MSI installers can be found here. This is the latest stable version. Download and execute to install. Verify Installation Use the WindowsKey + R, type cmd. Alternatively, navigate to the .sbt (for example, in C:\Users\Hopper) and type cmd in the address bar. Type sbt about t...

Full official instructions can be found here. MacPorts Install MacPorts. Then, in the terminal execute: port install sbt Homebrew Install Homebrew. Then, in the terminal execute: brew install sbt Sources Download sbt All platforms (tgz) installation from SBT. sudo su cd /opt mkdir sbt...

SOAP (Simple Access Object Protocol) is XML based, like XML-RPC, is ancestor, with file called WSDL, what describe the method to be exposed. This protocol is often based with SOAP-Enveloppe, a SOAP-Body, and alternatively SOAP-Header, the data is envelopped in a structure and be interpreted as the ...

Sometimes a build combines multiple source directories, each of which is their own 'project'. For instance, you might have a build structure like this: projectName/ build.sbt project/ src/ main/ ... test/ ... core/ src/ main/ ... test/ ... webapp/ src/ main/ ... test/ ... In t...

If one does not want to receive any alert for a specific host or service - at least momentarily - one can squelch it. alert thisis.down { macro = host.mymacro template = mytemplate $notes = This alert will... $metric = "avg:os.service.running{host=*,name=... warn = min( a($metri...

If you are a visually oriented person, this Venn diagram may help you understand the different types of JOINs that exist within MySQL.

To make tabs fade in, add .fade to each .tab-pane. The active tab pane must also have .in class to make the initial content visible. <ul class="nav nav-tabs" role="tablist"> <li role="presentation"> <a href="#id-of-content-1" role...

In Haskell, you can define any infix operator you like. For example, I could define the list-enveloping operator as (>+<) :: [a] -> [a] -> [a] env >+< l = env ++ l ++ env GHCi> "**">+<"emphasis" "**emphasis**" You should always give s...