Jul 24, 2025 · 6 min read · 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...
Join discussionJul 10, 2025 · 2 min read · 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...
Join discussion
Jul 10, 2025 · 3 min read · 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...
Join discussion
Jul 10, 2025 · 3 min read · 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...
Join discussion
Jul 10, 2025 · 2 min read · 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...
Join discussion
Jul 10, 2025 · 1 min read · Question: My table contains a value json-column: { "id":"string", "user":int, "history":{ "unixtimestamp":{ "progress":"string", "editorId":int }, "unixtimestamp":{ "progress":"s...
Join discussion
Jul 10, 2025 · 2 min read · 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...
Join discussion
Jul 10, 2025 · 4 min read · 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...
Join discussion
Jul 10, 2025 · 2 min read · 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...
Join discussion
Jul 10, 2025 · 4 min read · 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...
Join discussion