Search
 
SCRIPT & CODE EXAMPLE
 

SQL

power query add row

Insert two rows into the table at position 1.

Table.InsertRows(
    Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}),
    1,
    {
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
        [CustomerID = 3, Name = "Paul", Phone = "543-7890"]
    }
)
Comment

PREVIOUS NEXT
Code Example
Sql :: TSQL function split string 
Sql :: drop database using terminal postgres 
Sql :: convert dd/mm/yyyy to yyyy-mm-dd in sql server 
Sql :: oracle list primary key 
Sql :: Add colum sqlite table 
Sql :: deleting database in sql 
Sql :: SQL BACKUP DATABASE for SQL Server 
Sql :: sqlite alter table add multiple column 
Sql :: sub query postgres 
Sql :: oracle chain rules 
Sql :: oracle ddl 
Sql :: sql query inner join 3 tables 
Sql :: homebrew install mysql 
Sql :: mysqli inner join (php) 
Sql :: show function mysql 
Sql :: select mysql limit to 2 decimal places 
Sql :: sum sqlserver 
Sql :: postegresql update to null 
Sql :: how to select all fieldsin a soql query 
Sql :: print boolean in plsql 
Sql :: Create the connection pool mysql2 
Sql :: google cloud sql postgres url example 
Sql :: get current date sql 
Sql :: sql server select record with max id 
Sql :: T sql less than date 
Sql :: select only distinct values another table 
Sql :: minus equivalent in my sql 
Sql :: oracle step procedure 
Sql :: How To Rename Table Using MySQL RENAME TABLE Statement 
Sql :: create a plsql object 
ADD CONTENT
Topic
Content
Source link
Name
6+6 =