This is my code MERGE OrderDetailsStructure AS Target USING SalesOrderData AS Source ON Source.WebOrderNo=Target.WebOrderNo WHEN NOT MATCHED BY TARGET THEN INSE
I have been trying to download SQL Server on my Mac with an Apple Chip. I've been following the steps that include downloading docker and entering code into my
I am trying to upload a range of data in excel (same structure as target SQL table) to a table in SQL server using VBA. I do not want to loop row by row but tra
I work on sql server 2017 I need to delete all rows from table student_course but I don't know which is best for use delete from student_course OR truncate tab
I have written the code to create the subscriptions by adding the reference to ReportService2010.asmx. Please see the below screenshot for code and result [Id =
I have a SQL Server database which is maintain through Entity Framework Core. Every time I need a change of the database schema, I just generate a new migration
I'm running a SQL Server system (SS2019), which currently uses Merge Replication, and is about to be converted to using Transactional Replication. I'm (painfull
I have the following table as example. I want to retrieve only the records where the ScheduleDate is smaller than 2022-01-03 (Jan 3, 2022) for either the parent
I'm trying implement the follow query in LINQ, but I don't find solution: SQL: SELECT COUNT(*) AS AmountMonths FROM (SELECT SUBSTRING(CONVERT(NVARCHAR(12), pay_
I have a set of records in a db table like this. The thing that logically links these records is guid1 and guid2 but not all records in the table have a full re
I used this code to store attachment xlsx files from a specific address email in Outlook, but now I would like to store these files in a database in SQL Server,
hi all im trying to run a stored procedure using python however im getting an error below is my code import pyodbc import sqlalchemy from urllib.parse import qu
I'm looking for a one click system that doesn't require one to delete the Azure database, publish from the local server, and re-create the user info onto the de
I declared a variable @avgMis as a decimal(2,2) in SQL Server. Then I tried to divide two integers, expecting a decimal value. Instead my answ
I have an Azure DataFactory copy task set up to copy employee data from a MySQL database to a SQL Server database. The data copies over fine except for the fac
I have an event-based csv file that logs an event along with the time of execution. I need to be able to get the duration between the events by taking the DateT
I am developing an ASP.NET website with a SQL Server 2019 LocalDB database. I was working in Windows 10 ver:1903, but after upgrading Windows to the latest vers
Background: I'm doing some proofing of SQL Server 2019's _UTF8 collations (ref. https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-a
Recently I noticed that our spring-boot services are logging a warning from org.springframework.data.convert.CustomConversions. The message is this: Registerin
after days of research and fails with this problem. Context: I need to connect remotely from a python script to a remote database and I have the following restr