Tutorial by Examples: by

If the ORDER BY clause is specified in your update SQL statement, the rows are updated in the order that is specified. If LIMIT clause is specified in your SQL statement, that places a limit on the number of rows that can be updated. There is no limit, if LIMIT clause not specified. ORDER BY and L...

ContactManager contactManager = Factory.CreateObject("tracking/contactManager", true) as ContactManager; Contact contact = contactManager.LoadContactReadOnly(userName); return contact;

When you use GROUP BY clause, SQL Server query optimizer (QO) can choose different types of grouping operators: HASH Aggregate that creates hash-map for grouping entries Stream Aggregate that works well with pre-ordered inputs You can explicitly require that QO picks one or another aggregate ...

Prerequisites Install pods in your project Install the GooglePlaces SDK Enable location services First we need to get the users location by getting their current longitude and latitude. Import GooglePlaces and GooglePlacePicker import GooglePlaces import GooglePlacePicker Add the...

For example, we need to create two visualisations, "Before" and "After", and use dynamic filter for the date of the split. Let's say our query is called table. Add an additional date table with possible dates of the split. Add a slicer control with the table added ...

It's also possible to use selectors together. This is done by using the OpenQA.Selenium.Support.PageObjects.ByChained object: element = driver.FindElement(new ByChained(By.TagName("input"), By.ClassName("class")); Any number of Bys can be chained and are used as an AND type ...

If you want to sort your data numerically or alphabetically, you can simply use order by [column]. If you want to sort using a custom hierarchy, use a case statement. Group ----- Total Young MiddleAge Old Male Female Using a basic order by: Select * from MyTable Order by Group retur...

The HTTP response status code 301 Moved Permanently is used for permanent URL redirection, meaning current links or records using the URL that the response is received for should be updated. The new URL should be provided in the Location field included with the response. The 301 redirect is consider...

require "selenium-webdriver" driver = Selenium::WebDriver.for :chrome driver.execute_script("alert('running javascript');")

One implementation of the io.Reader interface can be found in the bytes package. It allows a byte slice to be used as the source for a Reader. In this example the byte slice is taken from a string, but is more likely to have been read from a file or network connection. message := []byte("Hello...

Command Structure is sqlcmd -S yourservername\instancename -d database_name -o outputfilename_withpath -Q "your select query" Switches are as follows -S for servername and instance name -d for source database -o for target outputfile (it will create output file) -Q fo...

CREATE CERTIFICATE My_New_Cert FROM FILE = 'D:\Temp\CertTest\certificateDER.cer' GO Create the certificate SELECT EncryptByCert(Cert_ID('My_New_Cert'), 'This text will get encrypted') encryption_test Usually, you would encrypt with a symmetric key, that key would get encrypted by the asym...

-- Create the key and protect it with the cert CREATE SYMMETRIC KEY My_Sym_Key WITH ALGORITHM = AES_256 ENCRYPTION BY CERTIFICATE My_New_Cert; GO -- open the key OPEN SYMMETRIC KEY My_Sym_Key DECRYPTION BY CERTIFICATE My_New_Cert; -- Encrypt SELECT EncryptByKey(Key_GUID('SSN_Key_01'),...

A particular instance of an entity class can be loaded as follows: Foo foo = fooRepository.findOne(id); The findOne method is provided by the CrudRepository interface. It expects an identifier that uniquely identifies an entity instance (for instance, a primary key in a database table). The Java...

Checking the Existence of Keys Sometimes you may need to check if a key already exists and proceed accordingly. To do so you can use exists() function as shown below: client.exists('key', function(err, reply) { if (reply === 1) { console.log('exists'); } else { cons...

SELECT EncryptByPassphrase('MyPassPhrase', 'This text will get encrypted') This will also encrypt but then by passphrase instead of asymmetric(certificate) key or by an explicit symmetric key.

Query: query:/sitecore/content/home/foo/bar Result bar

using System; [assembly:CLSCompliant(true)] namespace CLSDoc { public class Car { internal UInt16 _yearOfCreation = 0; //Warning CS3008 Identifier '_numberOfDoors' is not CLS-compliant //Warning CS3003 Type of 'Car._numberOfDoors' is not CLS-compli...

Debugging by raising exceptions is far easier than squinting through print log statements, and for most bugs, its generally much faster than opening up an irb debugger like pry or byebug. Those tools should not be your first step. Debugging Ruby/Rails Quickly: 1. Fast Method: Raise an Exceptio...

String to immutable ubyte[] string s = "unogatto"; immutable(ubyte[]) ustr = cast(immutable(ubyte)[])s; assert(typeof(ustr).stringof == "immutable(ubyte[])"); assert(ustr.length == 8); assert(ustr[0] == 0x75); //u assert(ustr[1] == 0x6e); //n assert(ustr[2] == 0x6f); //o...