Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: record

How to get the column names of a RECORD?

By adminPosted on September 24, 2022

Question : I have a function that declares: DECLARE r RECORD; The data on this record varies and at some […]

Change the row position of a record without messing anything else MySQL?

By adminPosted on August 2, 2022

Question : Hi I would like to ask if there is a smart way to change the record position of […]

Difference between return next and return record

By adminPosted on July 20, 2022

Question : What is the difference between RETURN NEXT and RETURN RECORD in PL/pgSQL? I find the manual quite confusing […]

What is the difference between a “record” and a “row” in SQL Server?

By adminPosted on December 8, 2021

Question : There was a rather innocuous question about adding dates and times in SQL Server that set off a […]

Return both one value and one column from pl/pgsql function

By adminPosted on July 9, 2021

Question : I wish my pl/pgsql function to go fetch and return two informations in my database in a single […]

SQL Server: ODBC Linked Server to Oracle does not return all rows

By adminPosted on January 19, 2021

Question : Let’s say we have one SQL Server instance on one side: SQL Server 2008 R2 SP3 Oracle 11.2 […]

Recent Posts

  • Force NOW to return new timestamps without committing the transaction
  • MariaDB on Windows Server 2012 R2 – out of memory
  • How to easily convert a comma seperated list of ids into a table of rows
  • clusterdb stopped working for PostgreSQL database in Ubuntu 12.04 server
  • Slow MySQL query
  • Database design : hotel room and its detail
  • How to use GROUP BY in an efficient way without losing attributes? [closed]
  • Query execution time is random, need to identify the root cause
  • Returning data where all categories exactly match
  • Partitioning increases CPU usage in mariadb
  • How to script out push subscription creation at the subscriber?
  • Can a transitive join loop infinitely?
  • 2 similar queries in large sql server table – 1 takes too long
  • Select data from another database instance on the same server in sql server
  • Is it possible to get server roles and database roles in a same query/script?
  • UPDATE performance where no data changes
  • Can I parse a text value from a specific column in a query (MySQL)?
  • MSSQL Geography STIntersects returns 1 when 0 is expected
  • Shrinking log files with SMO
  • What ports should I leave open for MySQL – Ubuntu server [closed]

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding