Tutorial by Examples: le

SQL Server 2008 R2 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ This transaction isolation level is slightly less permissive than READ COMMITTED, in that shared locks are placed on all data read by each statement in the transaction and are held until the transaction completes, as opposed to b...

SQL Server 2008 R2 SET TRANSACTION ISOLATION LEVEL SERIALIZEABLE This isolation level is the most restrictive. It requests range locks the range of key values that are read by each statement in the transaction. This also means that INSERT statements from other transactions will be blocked if the...

We can create it by two way. First from database properties designer mode: And by sql scripts: USE master; GO -- Create the database with the default data -- filegroup and a log file. Specify the -- growth increment and the max size for the -- primary data file. CREATE DATABASE TestDB ON...

CROSS APPLY enables you to "join" rows from a table with dynamically generated rows returned by some table-value function. Imagine that you have a Company table with a column that contains an array of products (ProductList column), and a function that parse these values and returns a set ...

CROSS APPLY enables you to "join" rows from a table with collection of JSON objects stored in a column. Imagine that you have a Company table with a column that contains an array of products (ProductList column) formatted as JSON array. OPENJSON table value function can parse these values...

It is well known that you cannot use the same file for input and ouput in the same command. For instance, $ cat header.txt body.txt >body.txt doesn’t do what you want. By the time cat reads body.txt, it has already been truncated by the redirection and it is empty. The final result will be th...

In Julia, when looping through an iterable object I is done with the for syntax: for i = I # or "for i in I" # body end Behind the scenes, this is translated to: state = start(I) while !done(I, state) (i, state) = next(I, state) # body end Therefore, if you wan...

You can list all files ignored by git in current directory with command: git status --ignored So if we have repository structure like this: .git .gitignore ./example_1 ./dir/example_2 ./example_2 ...and .gitignore file containing: example_2 ...than result of the command will be: $ g...

readarray -t arr <file Or with a loop: arr=() while IFS= read -r line; do arr+=("$line") done <file

while IFS= read -r line; do echo "$line" done <file If file may not include a newline at the end, then: while IFS= read -r line || [ -n "$line" ]; do echo "$line" done <file

Let's assume that the field separator is : (colon) in the file file. while IFS= read -d : -r field || [ -n "$field" ]; do echo "$field" done <file For a content: first : se con d: Thi rd: Fourth The output is: **first ** ** se con d** ** Thi ...

Let's assume that the field separator is : arr=() while IFS= read -d : -r field || [ -n "$field" ]; do arr+=("$field") done <file

This counts the number of lines in a big file with wc -l while simultaneously compressing it with gzip. Both run concurrently. tee >(wc -l >&2) < bigfile | gzip > bigfile.gz Normally tee writes its input to one or more files (and stdout). We can write to commands instead of fil...

The following function reads an entire file into a new string and returns it: (defun read-file (infile) (with-open-file (instream infile :direction :input :if-does-not-exist nil) (when instream (let ((string (make-string (file-length instream)))) (read-sequence string instr...

To get started: Install celery pip install celery configure celery (head to the remarks section) from __future__ import absolute_import, unicode_literals from celery.decorators import task @task def add_number(x, y): return x + y You can run this asynchronously by using the ....

class ImageCreationExample { static Image createSampleImage() { // instantiate a new BufferedImage (subclass of Image) instance BufferedImage img = new BufferedImage(640, 480, BufferedImage.TYPE_INT_ARGB); //draw something on the image paintOnI...

To transfer a file securely to another machine - type: scp file1.txt tom@server2:$HOME This example presents transferring file1.txt from our host to server2's user tom's home directory.

scp can also be used to transfer multiple files from one server to another. Below is example of transferring all files from my_folder directory with extension .txt to server2. In Below example all files will be transferred to user tom home directory. scp /my_folder/*.txt tom@server2:$HOME

To download a file from remote server to the local machine - type: scp tom@server2:$HOME/file.txt /local/machine/path/ This example shows how to download the file named file.txt from user tom's home directory to our local machine's current directory.

Internal Table Declaration Based on Local Type Definition " Declaration of type TYPES: BEGIN OF ty_flightb, id TYPE fl_id, dat TYPE fl_date, seatno TYPE fl_seatno, firstname TYPE fl_fname, lastname TYPE fl_lname, fl...