IEEE

AES-SQL: Text-to-SQL Based on Adaptive Prompting and Intelligent Example Selection

Abstract: Large Language Models have greatly enhanced the Text-to-SQL task. In this paper, we propose AES-SQL, an LLM-based approach based on few-shot Learning. We adjust the structure of the adaptive ...
GitHub

-- SQL Server 2022 Diagnostic Information Queries

-- 16.0.1050.5 RTM GDR 2/14/2023 https://support.microsoft.com/en-us/topic/kb5021522-description-of-the-security-update-for-sql-server-2022-gdr-february-14-2023 ...
GitHub

Q&A_Glovo_SQL_Technical_Interview.md

--SQL Server code for Q1 resolution SELECT o.id AS order_id, p.latitude AS pickup_latitude, p.longitude AS pickup_longitude, d.latitude AS delivery_latitude, d.longitude AS delivery_longitude, ROUND( ...
IEEE

SQL Synthesis with Input-Output Example Based on Deep Learning

Abstract: In recent years, an increasing number of people rely on data manipulation tasks to complete their work. However, many of these users lack programming background and find it challenging to ...
Microsoft

Working with time series data in SQL Server 2022 and Azure SQL

Part of the SQL Server 2022 blog series. Time series data is a set of values organized in the order in which they occur and arrive for processing. Unlike transactional data in SQL Server, which is not ...
Microsoft

Working with date/time values and SQL Server

TL;DR: if you want to use date/time values from a SQL Server table in PowerApps, use the datetimeoffset column type and your life will be easier. The datetime (and friends) column type represent an ...