About 1,789,095 results (4,841 milliseconds)
Specify nested and repeated columns in table schemas | BigQuery ...
https://cloud.google.com/bigquery/docs/nested-repeated Notice that the addresses column contains an array of values (indicated by [ ] ). The multiple addresses in the array are the repeated data. The multiple fields ...
Manage column store content manually | AlloyDB for PostgreSQL ...
https://cloud.google.com/alloydb/docs/columnar-engine/manage-content-manually Query evaluation automatically uses the stored columnar data to answer queries. ... Drop columns using SQL functions. Run the google_columnar_engine_drop SQL ...
Empty string in H2 and Oracle
https://groups.google.com/g/h2-database/c/BcEvk0psaXc Jun 9, 2011 ... The same behaviour appears when reading the values from a table. ... We use H2 for unit-testing and Oracle (or SQL Server) is the production ...
Introduction to column-level access control | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/column-level-security-intro Data masking lets you mask sensitive data by substituting null, default, or hashed content in place of the column's actual value. Column-level access control ...
UTF8 characters in database, table and column names
https://groups.google.com/g/sql-workbench/c/DrkG3u1nX50 I know it's very bad but MySQL allows this, so why not. On SQL Workbench 121 it can't load database's names in Database Explorer. Apparently it's fixed on build ...
Improve the speed of Sync - AppSheet Help
https://support.google.com/appsheet/answer/10104985?hl=en If your worksheets contain empty columns, you can greatly improve performance by deleting them. A spreadsheet workbook (that is, file) contains one or more ...
Secondary indexes | Spanner | Google Cloud
https://cloud.google.com/spanner/docs/secondary-indexes All key columns from the base table; All columns that are included in the index; All columns specified in the optional STORING clause (GoogleSQL-dialect ...
Missing double quotes around table and column names
https://groups.google.com/g/jooq-user/c/469obN2diSM ... SQL Server, where people tend to PascalCase also their table / column names. ... SQL) is the String (as in bind value) type. With all the convenience ...
Schemas overview | Spanner | Google Cloud
https://cloud.google.com/spanner/docs/schema-and-data-model A table with no primary key columns can only have one row. Only GoogleSQL-dialect databases can have tables without a primary key. Often your application ...
How to add timestamp to message payload ?
https://groups.google.com/g/node-red/c/ff5chUeXhJI Nov 17, 2014 ... Other users, in our plant can pull data from our SQL server tables into their own MS Access applications. ... set the default value in the table ...
Cannot drop the table because it is being used for replication.
https://groups.google.com/g/microsoft.public.sqlserver.replication/c/zsMK--CF4MY Mar 3, 2004 ... I have replication setup between two SQL 2000 servers, I want to change the size of a column on the publisher and I get the following error.
SqlAlchemy Insert error
https://groups.google.com/g/sqlalchemy/c/fiKp93y3Jgk Feb 11, 2008 ... I have a table in SQL Server V.8 where I am trying to insert a row ... column which is an autoincrementing integer value, MS-SQL requires
How to implement Contains(field, value) in JOOQ
https://groups.google.com/g/jooq-user/c/pmAR8IBiWVw Feb 23, 2021 ... contains("value")) -> the query is generated like this: ... Besides, even SQL Server users might use *our* contains, rather than SQL Server's as a ...
reset IDENTITY field
https://groups.google.com/g/h2-database/c/z7HmvPmvjV8 Feb 11, 2011 ... For other storage engines, TRUNCATE TABLE differs from DELETE in the ... columns as in MySQL and MS SQL Server (and possibly other databases).
sql: problems with time.Time
https://groups.google.com/g/golang-nuts/c/4ebvN6Bgv3M Time have when it is parsed from a TIME / DATE / DATETIME value? UTC? The server's timezone? This is very likely to have unexpected results and probably leads ...
Delete data from Cloud Firestore | Firebase
https://firebase.google.com/docs/firestore/manage-data/delete-data If you need to delete entire collections, do so only from a trusted server environment. While it is possible to delete a collection from a mobile/web client, ...
Data Pumper & WbCopy
https://groups.google.com/g/sql-workbench/c/sdKL5x79CSs Postgres or SQL Server). I drop the table in "Database Explorer" and there is no commit there. Then I drop the table via SQL and if I make commit I have an ...
Manage search indexes | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/search-index Dec 25, 2008 ... If you delete the only indexed column in a table or rename the table itself, then the search index is deleted automatically. Search indexes are ...
Error on upgrade of h2 from 1.4.200 to 2.0.204
https://groups.google.com/g/ebean/c/_sdyThBB1QI Executing mj_online-drop-all.sql - 121 statements, autoCommit:true ... So the options are to use the NON_KEYWORDS option in the jdbc url or move away from using ...
Using "ALTER TABLE ADD..." to add multiple columns
https://groups.google.com/g/h2-database/c/Kg4dB64ySfg So does Microsft SQL Server's T-SQL: ALTER TABLE customer ADD foo INTEGER ... + stat.execute("drop table t"); + stat.execute("create table t(x varchar) ...