Tutorial by Examples: le

Yu can define format of the file that will be imported using FORMATFILE option: INSERT INTO mytable SELECT a.* FROM OPENROWSET(BULK 'c:\test\values.txt', FORMATFILE = 'c:\test\values.fmt') AS a; The format file, format_file.fmt, describes the columns in values.txt: 9.0 2 1 SQ...

You can use OPENROWSET to read content of file and pass it to some other function that will parse results. The following example shows hot to read entire content of JSON file using OPENROWSET(BULK) and then provide BulkColumn to OPENJSON function that will parse JSON and return columns: SELECT boo...

There’s a tempting existing field called profile that is added by default when a new user registers. This field was historically intended to be used as a scratch pad for user-specific data - maybe their image avatar, name, intro text, etc. Because of this, the profile field on every user is automati...

A basic implementation for singly-linked-list in java - that can add integer values to the end of the list, remove the first value encountered value from list, return an array of values at a given instant and determine whether a given value is present in the list. Node.java package com.example.so....

READ data-file

This is a contrived sample. It sorts records based on an ALPHABET that has upper and lower case characters together, with A and a swapped compared to the other letters. This was done on purpose to demonstrate the possibilities. The SORT algorithm reader retrieves records using RELEASE in the INPU...

Assuming you have a model that looks like the following, we will get up an running with a simple barebones read-only API driven by Django REST Framework ("DRF"). models.py class FeedItem(models.Model): title = models.CharField(max_length=100, blank=True) url = models.URLField(b...

Selecting data with condition $query = $this->db->select('*') ->from('table_name') ->where('column_name', $value) // Condition ->get(); return $query->result(); Selecting data with multiple conditions $conditions =...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task; task body My_Task is begin Put_Line ("Hello from My_Task"); end; begin Put_Line ("Hello from Main"); end; Result The order of Put_Line can vary. Hello from My_Task Hello from ...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task; task body My_Task is begin for I in 1 .. 4 loop Put_Line ("Hello from My_Task"); end loop; end; begin Put_Line ("Hello from Main"); end; Result The order of Put...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task; task body My_Task is begin for I in 1 .. 4 loop Put_Line ("Hello from My_Task"); end loop; end; begin for I in 1 .. 4 loop Put_Line ("Hello from Main"); e...

with Ada.Text_IO; use Ada.Text_IO; procedure Main is task My_Task_1; task My_Task_2; task body My_Task_1 is begin for I in 1 .. 4 loop Put_Line ("Hello from My_Task_1"); end loop; end; task body My_Task_2 is begin for ...

select owner, table_name from all_tables ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user. COLS is a synonym for USER_TAB_COLUMNS. select * from all_tab_columns where table_name = :tname

All roles granted to user. select * from dba_role_privs where grantee= :username Privileges granted to user: system privileges select * from dba_sys_privs where grantee = :username object grants select * from dba_tab_privs where grantee = :username Permissions grante...

select * from v$version

Query store can be enabled on database by using the following command: ALTER DATABASE tpch SET QUERY_STORE = ON SQL Server/Azure SQL Database will collect information about executed queries and provide information in sys.query_store views: sys.query_store_query sys.query_store_query_text sy...

ObservableCollection is a collection of type T like List<T> which means that it holds objects of type T. From documentation we read that : ObservableCollectionrepresents a dynamic data collection that provides notifications when items get added, removed, or when the entire list is refres...

files = list.files(pattern="*.csv") data_list = lapply(files, read.table, header = TRUE) This read every file and adds it to a list. Afterwards, if all data.frame have the same structure they can be combined into one big data.frame: df <- do.call(rbind, data_list)

LINQ extension methods on IEnumerable<T> take actual methods1, whether anonymous methods: //C# Func<int,bool> fn = x => x > 3; var list = new List<int>() {1,2,3,4,5,6}; var query = list.Where(fn); 'VB.NET Dim fn = Function(x As Integer) x > 3 Dim list = New List F...

Add the readonly attribute to prevent user input. A readonly field can't be edited <input class="form-control" type="text" placeholder="Readonly input here…" readonly> Add the disabled attribute to disable an input field. A disbled field can't be edited either...