Tutorial by Examples: ble

When multiple variables are defined at the beginning of the batch, a short definition form may be used by employing a replacement string. @echo off set "vars=_A=good,_B=,_E=bad,_F=,_G=ugly,_C=,_H=,_I=,_J=,_K=,_L=,_D=6 set "%vars:,=" & set "%" for /f %%l in ('set _'...

It is possible to create a set of variables that can act similar to an array (although they are not an actual array object) by using spaces in the SET statement: @echo off SET var=A "foo bar" 123 for %%a in (%var%) do ( echo %%a ) echo Get the variable directly: %var% Result: ...

Here are some ways to set variables: You can set a variable to a specific, string, number, date using SET EX: SET @var_string = 'my_var'; SET @var_num = '2' SET @var_date = '2015-07-20'; you can set a variable to be the result of a select statement using := EX: Select @var := '123'; (...

If you have a "child table" formatted as JSON collection and stored in-row as JSON column, you can unpack this collection, transform it to table and join it with parent row. Instead of the standard JOIN operator, you should use CROSS APPLY. In this example, product parts are formatted as ...

If you can use memory-optimized tables, you can store JSON as text: CREATE TABLE ProductCollection ( Id int identity primary key nonclustered, Data nvarchar(max) ) WITH (MEMORY_OPTIMIZED=ON) Advantages of JSON in in-memory: JSON data is always in memory so there is no disk access Ther...

CommandUsageaboutShort information about ComposerarchiveCreate an archive of this composer packagebrowseOpens the package's repository URL or homepage in your browser.clear-cacheClears composer's internal package cache.clearcacheClears composer's internal package cache.configSet config optionscreate...

sqoop import \ --connect <rdbms-jdbc-url> \ --username <username> \ --password <password> \ --table <table-name> Example with Mysql: sqoop import \ --connect jdbc:mysql://mysql.example.com/testdb \ --username root \ --password root \ --table employees CSV file ...

Using --where tag sqoop import \ --connect <rdbms-jdbc-url> \ --username <username> \ --password <password> \ --table <table-name> \ --where "<condition>" Example with Mysql: sqoop import \ --connect jdbc:mysql://mysql.example.com/testdb \ --userna...

C99 Since C99, C has variable length arrays, VLA, that model arrays with bounds that are only known at initialization time. While you have to be careful not to allocate too large VLA (they might smash your stack), using pointers to VLA and using them in sizeof expressions is fine. double sumAll(si...

The disabled binding adds a disabled attribute to a html element causing it to no longer be editable or clickable. This is useful mainly for <input>, <select>, <textarea>, <a> and <button> elements <input data-bind="disabled: disableInput"/> <sc...

img{ float:left; width:100px; margin:0 10px; } .div1{ background:#f1f1f1; /* does not create block formatting context */ } .div2{ background:#f1f1f1; overflow:hidden; /* creates block formatting context */ } https://jsfiddle.net/MadalinaTn/qkwwmu6m/2/ Using the o...

HTML: <div class="wrapper"> <div class="outer"> <div class="inner"> centered </div> </div> </div> CSS: .wrapper { height: 600px; text-align: center; } .outer { display: table; ...

A spannable TextView can be used in Android to highlight a particular portion of text with a different color, style, size, and/or click event in a single TextView widget. Consider that you have defined a TextView as follows: TextView textview=findViewById(R.id.textview); Then you can apply diff...

The @switch annotation tells the compiler that the match statement can be replaced with a single tableswitch instruction at the bytecode level. This is a minor optimization that can remove unnecessary comparisons and variable loads during runtime. The @switch annotation works only for matches again...

Rebuilding indexes is done using the following statement ALTER INDEX All ON tableName REBUILD; This drops the index and recreates it, removing fragementation, reclaims disk space and reorders index pages. One can also reorganize an index using ALTER INDEX All ON tableName REORGANIZE; which ...

Document level It is on by default, but you can set it by placing Option Infer On|Off at the top of the code file. The option will apply to the whole document. Project level You can switch it on/off via the menu in Visual Studio: Project > [Project] Properties > Compile Tab > Option i...

While catching the Throwable, Exception, Error and RuntimeException exceptions is bad, throwing them is even worse. The basic problem is that when your application needs to handle exceptions, the presence of the top level exceptions make it hard to discriminate between different error conditions. ...

SELECT * INTO NewTable FROM OldTable Creates a new table with structure of old table and inserts all rows into the new table. Some Restrictions You cannot specify a table variable or table-valued parameter as the new table. You cannot use SELECT…INTO to create a partitioned table, even whe...

The following example can be used to find the total row count for a specific table in a database if table_name is replaced by the the table you wish to query: SELECT COUNT(*) AS [TotalRowCount] FROM table_name; It is also possible to get the row count for all tables by joining back to the table'...

/** * Created by Nick Cardoso on 03/08/16. * This is not a complete parcelable implementation, it only highlights the easiest * way to read and write your Enum values to your parcel */ public class Foo implements Parcelable { private final MyEnum myEnumVariable; private final M...