I'm working with Postgres from SSIS thru ODBC Unicode driver ver 13.01. 32-bit connection. I can successfully connect to all Postgres tables but can not able t
Can I use SqlConnection in Xamarin.Forms? I tend to use this in Windows and Web applications developed in Visual Studio, but I don't know how it would work in
I am attempting to display a table from my Azure SQL database on a webpage. I have been looking around and can't seem to figure out why this isn't working This
Here's an example of a connection configuration that has stopped working (it's for connecting to an Azure managed database): { "server": "sqldb.12345abcde.dat
I have a CRM software on my local machine. In the SQL DB of the software, I added a linked server (our test website with our test DB: Windows Small Business Ser
I have a data that combines inventory, sales forecast, and future supply data for different parts. I have combined it to give me a table that gives a net quanti
I am trying to connect to an Azure database using SQLAlchemy in Python. My code is the following: engine_azure = \ create_engine('mssql+pyodbc://{Server admin
I am trying to create a report table in SSRS 2016 but I am not sure how to go about it or if it is possible. I am trying to recreate something similar to that
I use lookup tables commonly and sometimes I have some default record in the Lookup table and I think for this record I can use 0 as Primary Key a as shown belo
I'm trying to create a query with a variable number of parameters, giving to the program the name of the table and an Array for the names of parameters and anot
Laravel version:7.13, SqlServer:2019 SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: An existing connection was forcibly closed by
Parent: public class Currency { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public string? Name { get; set; }
I need help with writing the query that will say month difference between return and purchase dates, see the example below. Product PurchaseDate (dd/mm/yy) Ret
Write a query identifying the type of each record in the TRIANGLES table using its three side lengths. Output one of the following statements for each record in
I have a scenario where during an Update request of a parent entity, I have a collection of children entities in my dto, and want to merge them in the DB so tha
In my R script for MS SQL Server I try to return one column VARBINARY() and one VARCHAR(). However, server allow only one column when VARBINARY is returned: T
I've been running a schema compare in a database project in Visual Studio 2017, when I do this I get the following message in the Error List tab: Unexpected
I have a query like this return await _ctx.Activities .Include(a => a.Attributes) .Include(a => a.Roles) .Include(a =
I'm trying to perform a PIVOT but getting an error. I'm trying to see which patients have more than one Interval session. The column is a text type. I attempted
I am trying to learn how to use transactions and error handling. Got stuck with custom error messages. The stored procedure generates badges for AdventureWorks