About 1,346,286 results (5,212 milliseconds)
BEWARE: Identity columns and datwindows... a very bad ...
https://groups.google.com/g/powersoft.public.powerbuilder.datawindow/c/DOfJEaPGw2A/m/q8ItMSrjQDEJ Jul 8, 1999 ... of MS SQL Server has a bug where the identity value returns Null when an insert ... Select Max() from a column will always return the max value of ...
Crazy Identity Numbers
https://groups.google.com/g/comp.databases.sybase/c/z-VeJrazmjA/m/ttmJbVtLrV4J becomes available. This method of choosing IDENTITY column values improves server performance. When SQL Server assigns a new column value, it reads the
GoogleSQL data definition language | Spanner | Google Cloud
https://cloud.google.com/spanner/docs/reference/standard-sql/data-definition-language ... value MAX , which is equivalent to 2621440 for validation purposes. ... This clause creates a column as an identity column, which is a column whose value is ...
Cannot insert strings with a length greater than 2000 into columns ...
https://groups.google.com/g/sqlalchemy/c/Kk6DkPNWlR4 Oct 13, 2020 ... [SQL: INSERT INTO msg (content) OUTPUT inserted.id VALUES (?) ... I've checked the MS SQL Server and it creates it column properly with e.g. ...
Primary key default values management | Spanner | Google Cloud
https://cloud.google.com/spanner/docs/primary-key-default-value You can use IDENTITY columns by either providing a starting integer value ... IDENTITY, name STRING(MAX), ) PRIMARY KEY (id);. ALTER DATABASE db SET spanner ...
Subscriber updatable transactional error.
https://groups.google.com/g/microsoft.public.sqlserver.replication/c/-hsbM_Djsko Feb 11, 2008 ... as a paste. 2008-02-13 00:15:04.071 Microsoft SQL Server Replication Queue Reader Agent ... 'Explicit value must be specified for identity column ...
group by needs to be part of the subquery
https://groups.google.com/g/scalaquery/c/ADOKjUZB-Q4/m/Ju7GcRu5DGYJ There are understandable mistakes when your mind is (still) set on SQL. You used (deprecated) aggregation functions .max/.min on columns and used groupBy AFTER ...
Migrating auto-incrementing keys to Spanner | Google Cloud Blog
https://cloud.google.com/blog/products/databases/migrating-auto-incrementing-keys-to-spanner/ Jan 24, 2024 ... ... IDENTITY type in SQL Server or Oracle. For databases that manage ... The column values are monotonically increasing. After migration ...
Migrate primary keys | Spanner | Google Cloud
https://cloud.google.com/spanner/docs/migrating-primary-keys ... ( GoogleSQL, PostgreSQL) function as the default value for the column. Migrate ... Id); ALTER TABLE MyFirstTable ALTER COLUMN Id ALTER IDENTITY RESTART COUNTER WITH ...
Google Code Archive - Google Code
https://code.google.com/archive/p/pyodbc/issues/277 Jul 17, 2012 ... When I try to insert a large value into a varbinary(max) column on SQL Server 2008 it is producing an error "The text, ntext, or image ...
General best practices | Cloud SQL for SQL Server | Google Cloud
https://cloud.google.com/sql/docs/sqlserver/best-practices Consider revisiting the value to match the recommended values for a new size. We recommend using the following formula to set the max server memory database ...
Return Primary Key of newly inserted row
https://groups.google.com/g/firebird-support/c/0cwc_As_AAU inserted record, including the value of an identity column, or a column ... `Select max(PK) from tableX` and then incrementing by one to produce the next ...
Ensemble reading HL7 from SQL Server
https://groups.google.com/g/ensemble-in-healthcare/c/-PqqanzBfv4 9/ Maximum HL7 record length coming in from SQL Server is unlikely to exceed 6,000 characters and the associated column in the SQL Server table is defined ...
Schema design best practices | Bigtable Documentation | Google ...
https://cloud.google.com/bigtable/docs/schema-design Since you have to store a column qualifier for every column, you can save space by naming the column with a value. ... maximum value for long integers (in Java, ...
Does DB2 have an equivalent to Oracle sequence?
https://groups.google.com/g/comp.databases.ibm-db2/c/9POyp3fZssw Jul 31, 1999 ... Id (probably with higher value than the largest existing User Id). MS SQL server has a concept called "identity" which does the similar ...
Performance: DROP TABLE very slow on large tables
https://groups.google.com/g/h2-database/c/rVW-slB7KRY was due the server creating a new/rollback version of the table + ... There were 5 million rows. There were 6 columns including an identity and a double value ...
Quotas and limits | BigQuery | Google Cloud
https://cloud.google.com/bigquery/quotas Maximum SQL query character length, 1,024k characters, A SQL query can be up ... Maximum columns in a table, query result, or view definition, 10,000 ...
Connecting Looker to your database | Google Cloud
https://cloud.google.com/looker/docs/connecting-to-your-db ... Max Connections per node value is equal to or lower than your database's limit. Connection Pool Timeout. If your users request more connections than the Max ...
Deep dive into PostgreSQL VACUUM garbage collector | Google ...
https://cloud.google.com/blog/products/databases/deep-dive-into-postgresql-vacuum-garbage-collector Jul 6, 2023 ... Cloud SQL provides metrics to monitor dead/live tuples and transaction id utilization. ... Specifies the maximum amount of memory to be ...
Usage and limits | Firestore | Firebase
https://firebase.google.com/docs/firestore/quotas Maximum number of composite indexes for a database. 200 when you have not enabled billing for your Google Cloud project. If you need more quota, you must enable ...