Tag feed

#qanda

14 posts0 followers

Explore Hashnode

Alternatives

Trending tags this week

KDKatherine Dsouzainfluencer-marketing-30.hashnode.devJul 24, 2025 · 6 min read

Mastering the Post-Webinar Funnel: What Happens After the Q&A?

The applause fades, the Q&A concludes, and your webinar session officially ends. For many, this marks the finish line. But for savvy marketers in 2025, the real work — and the greatest opportunity for conversion and revenue — has just begun. The post...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 2 min read

Update table according with JSON/JSONB

Question: I have a table books : Name of columnType idint (PK) nametext nb_pagesint And a table book_modifications : Name of columnType idint (PK) old_datajsonb new_datajsonb book_idint (FK) Now let's imagine I have a row in my...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 3 min read

Query run fast from MySQL CLI but very slow on R2dbcTemplate Code

Question: Currently, I having a query SELECT al.category, IFNULL(jt.name, 'Ungrouped Devices') AS device_group_name, IFNULL(jt.id, '00000000-0000-0000-0000-000000000000') AS device_group_id, jt.color_code AS color_code, COUNT(*) AS total FR...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 3 min read

Stop my temporary table from filtering out data unprompted

Question: I'm aggregating US county cost of living data, but I realized my temporary table is only returning rows for families without kids for some reason. For every county, there's a row for families from no kids to 4 kids for both 1 and 2 parent h...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 2 min read

Why does declare @x int = 1, @y int = @x; not work in SQL Server?

Question: This code: declare @x int = 1, @y int = @x; gives the error: Must declare the scalar variable "@x". I read through the Microsoft documentation for the DECLARE keyword along with some other sources, but none thoroughly explained this beha...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 1 min read

How can I SELECT rows where a JSON key is bigger/smaller than a certain date?

Question: My table contains a value json-column: { "id":"string", "user":int, "history":{ "unixtimestamp":{ "progress":"string", "editorId":int }, "unixtimestamp":{ "progress":"s...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 2 min read

How to simulate a deadlock on a row in MySQL?

Question: To simulate a lock in mysql I can grab the row with the following: BEGIN; SELECT * FROM table WHERE id=1 FOR UPDATE; Now, if I try and update that row (from another connection) it will raise the following error after innodb_lock_wait_timeo...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 4 min read

SQL BULK INSERT Format Issues

Question: I'm using SQL Server and Management Studio. I was getting data conversion errors when performing a BULK INSERT into a table, that I could not resolve and switching to using a format file allowed data to be inserted, but the data inserted wa...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 2 min read

How to handle existing data while enabling versioning on existing table?

Question: I am trying to enable system versioning to an existing table like this ALTER TABLE [dbo].[User] ADD ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START, ValidTo DATETIME2 GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo...

0

GBGabriella Barajasdatabasedev.hashnode.devJul 10, 2025 · 4 min read

SQL to join tables and get value from one table that has most recent date closest to date of parent record

Question: I have two tables, one a parent of the other, let's call them CUST and CUST_ADDR. Each table is a history table, so each time a value in one of the data fields changes, another record is added with the new value and a date it was changed. S...

0

#qanda

Search Hashnode

#qanda

Explore Hashnode

Trending tags this week

Mastering the Post-Webinar Funnel: What Happens After the Q&A?

Update table according with JSON/JSONB

Query run fast from MySQL CLI but very slow on R2dbcTemplate Code

Stop my temporary table from filtering out data unprompted

Why does declare @x int = 1, @y int = @x; not work in SQL Server?

How can I SELECT rows where a JSON key is bigger/smaller than a certain date?

How to simulate a deadlock on a row in MySQL?

SQL BULK INSERT Format Issues

How to handle existing data while enabling versioning on existing table?

SQL to join tables and get value from one table that has most recent date closest to date of parent record