Tutorial by Examples: er

SELECT string_agg(<TABLE_NAME>.<COLUMN_NAME>, ',') FROM <SCHEMA_NAME>.<TABLE_NAME> T

DELETE FROM <SCHEMA_NAME>.<Table_NAME> WHERE ctid NOT IN ( SELECT MAX(ctid) FROM <SCHEMA_NAME>.<TABLE_NAME> GROUP BY <SCHEMA_NAME>.<TABLE_NAME>.* ) ;

If the Control has rows. TextBox tb = GridView1.Rows[i].FindControl("TextBox1") as TextBox; Or if it has items. TextBox tb = Repeater1.Items[i].FindControl("TextBox1") as TextBox;

Add arbitrary paths to the Maya Python environment in the userSetup.py file. userSetup.py is a Python file (not a module) which gets automatically executed on Maya startup. userSetup.py can live in a number of locations, depending on the os and environment variables. When Maya starts, it will exe...

Docker's approach to logging is that you construct your containers in such a way, so that logs are written to standard output (console/terminal). If you already have a container which writes logs to a file, you can redirect it by creating a symbolic link: ln -sf /dev/stdout /var/log/nginx/access.l...

inline int add(int x, int y) { return x + y; }

// header (.hpp) struct A { void i_am_inlined() { } }; struct B { void i_am_NOT_inlined(); }; // source (.cpp) void B::i_am_NOT_inlined() { }

I need to query all the details from virtual machine and update into the MongoDB. Which require the output look like this. { "_id" : ObjectId("5800509f23888a12bccf2347"), "ResourceGrp" : "XYZZ-MachineGrp", "ProcessTime" : ISODate(&q...

$MachinesList # Array $ResourceList # Array $MachineTags # Array pseudo code $mongoDriverPath = 'C:\Program Files (x86)\MongoDB\CSharpDriver 1.7'; Add-Type -Path "$($mongoDriverPath)\MongoDB.Bson.dll"; Add-Type -Path &qu...

You must have installed Heroku Toolbelt first. Having an account in Heroku and installation of ember-cli-deploy are mandatory. Creating a new Heroku instance from an Ember CLI application's parent directory: $ heroku create --buildpack https://github.com/tonycoco/heroku-buildpack-ember-cli.git ...

The exchange methods of RestTemplate allows you specify a HttpEntity that will be written to the request when execute the method. You can add headers (such user agent, referrer...) to this entity: public void testHeader(final RestTemplate restTemplate){ //Set the headers you need send ...

XML <Deborah> <address>Dark world</address> <master>Babadi</master> <ID>#0</ID> <colour>red</colour> <side>evil</side> </Deborah> XPATH boolean(/Deborah/master/text()) OR string(/Deborah/master...

XML <Dobby> <address>Hogwartz</address> <master></master> <colour>wheatish</colour> <side>all good</side> </Dobby> XPATH boolean(/Dobby/master/text()) OR string(/Dobby/master) != '' OUTPUT false

From android 6.0 this permission needs to grant dynamically, <uses-permission android:name="android.permission.SYSTEM_ALERT_WINDOW"/> Throwing below permission denied error on 6.0, Caused by: android.view.WindowManager$BadTokenException: Unable to add window android.view.ViewRoo...

here you can find the functions. With the table wf_example created in previous example, run: select i , dense_rank() over (order by i) , row_number() over () , rank() over (order by i) from wf_example The result is: i | dense_rank | row_number | rank ---+------------+------------+-...

library(deSolve) ## ----------------------------------------------------------------------------- ## Define R-function ## ----------------------------------------------------------------------------- LV <- function(t, y, parms) { with(as.list(c(y, parms)), { dP &l...

We shall now see how the Image/File Uploading code works in the native CI method with the help of the forms that has been proposed by the CI way. File uploading in PHP has Two Scenarios. It is mentioned below as follows. Single Image/File uploader - This can be saved with the help of the normal ...

SET handle TO returned-pointer SET handle UP BY LENGTH(returned-pointer) SET ADDRESS OF buffer-space TO handle MOVE buffer-space TO work-store DISPLAY "Second element is " work-store

TERMINATE report-1 report-2 report-summary

\documentclass{beamer} When to use the beamer class ? For presentation slides. What are the specificities of this class ? The output is landscape-oriented. The document is separated in "frames" (slides). Simple example Following example was adapted from : sharelatex.com/learn/Beame...