I am trying to determine if it's possible to query for data between two defined HOUR values from a DateTime value, instead of writing out each DateTime iteration. This need is to find matching values ...

I need to build the following XML data structure. I get the XML structure that I need but I am missing the student tag. <users> <user> <id>123</id> <name&...

CTRL+G works: CTRL+B doesn't work: I've created a custom keyboard shortcut for Edit.Comment that works using CTRL+G. I used the same configuration for Edit.Uncomment using CTRL+B which is not ...

In one of my projects I have an entity with startDate (from) and expiryDate (to): @Entity public class BlacklistedItem { //... @Column(nullable = false) private LocalDateTime startDate; @...

I'm working on a .NET 8 application that uses SQL Server User-Defined Table Types (UDTT) to pass data to stored procedures. I have a situation where I need to ensure that my C# classes remain ...

I accidently ran an incorrect and incomplete query on production as shown in the following. #TempDiff is a temp table with 2 columns as shown below. There are one or many [Pallet Contents] for each ...

What is the best way to alter a production SQL Server 18 table's column size, varchar(n +1). My understanding would be the following: Shut the website down to stop the transaction from coming in. ...

I had Google Apps Script directly connected to my server that has SQL Server through JDBC to synchronize Google Sheets data (read rows, insert/update SQL records) for free, but since Thursday, March ...

I'm writing a report in Visual Studio that throws the following error when I run it: Query execution failed for dataset 'MyDataset' Incorrect syntax near ','. The report's query checker can't parse ...

I'm trying to connect Google Apps Script directly to my remote Azure SQL server using JDBC to sync data from Google Sheets (read rows, insert/update records in Azure SQL) for free, but I keep getting ...

I am using Visual Studio 2022 and trying to work with internal .mdf databases (LocalDB) for testing purposes in an ASP.NET Web Forms project using Entity Framework (EDMX). Creating the database itself ...

I have made problem during configure log shipping on SQL Server 2019 standard version by missing last backup, last copies, last restore select not found on msdb. I have been using user AD all machine ...

I am processing a task of migrating a set of Customer records from a data source into our own production Customer database which is SQL Server. I have migrated the incoming Customer records into a ...

In a stored procedure (version 2019), renaming a column of a #table to a @value stops working for subsequent executions. The #table retains/gets the @value name of the very first execution. Is this an ...

I'm testing client-side timeouts using PowerShell's Invoke-Sqlcmd: Invoke-Sqlcmd -Query "WAITFOR DELAY '00:00:31'" ` -Database master ` -ServerInstance $env:COMPUTERNAME Observed behavior: ...