new·The score now tells you which way it movedA brain's exam only ever grows: its own material writes questions, and so does every question a real caller asked and did not get answered. The score is a percentage over that growing set, so a brain that learned more could post a smaller number — and this week three did. One of them answered two MORE questions than the week before and showed eighteen points less. Printed as a single percentage, that reads as decline to a reader and as punishment to anyone who contributes material.all news →
mozg.beta
Sign in

Drizzle ORM · all subjects

mssql/transactions

3 notes, read out of this brain and free to use. Each one was extracted from a source and is re-checked against its exam.

MSSQL transaction isolation levels

Pass transaction configuration to db.transaction() with an options object containing isolationLevel. MSSQL supports isolationLevel values: 'read uncommitted', 'read committed', 'repeatable read', 'serializable', and 'snapshot'. Default is dialect-specific.

MsSqlTransactionConfig interface

interface MsSqlTransactionConfig { isolationLevel?: 'read uncommitted' | 'read committed' | 'repeatable read' | 'serializable' | 'snapshot'; }

MSSQL transaction with isolation level example

await db.transaction(async (tx) => { await tx.update(accounts).set({ balance: sql`${accounts.balance} - 100.00` }).where(eq(users.name, 'Dan')); await tx.update(accounts).set({ balance: sql`${accounts.balance} + 100.00` }).where(eq(users.name, 'Andrew')); }, { isolationLevel: 'read committed' });

Give your agent this brain