I am trying to run SQL Server DB index and statistics maintenance activating a stored procedure called AzureSQLMaintenance with a PowerShell Runbook in Automati
We are using sequelize package to connect to mssql server. Our backend code is in javascript. We have a working code like below: const sequelize = new Sequelize
I have been trying to insert data from a dataframe in Python to a table already created in SQL Server. The data frame has 90K rows and wanted the best possible
Back Story: So I've been recently developing some c# sharp projects using a m1 Mac and a sql image (sqledge) hosted in a docker container. When trying to connec
In First Image Only Select Statement is run , it works fine . but In Second Image when we added CTE and executed the query , it shows error. Can you please hel
I create a new image base on the "mcr.microsoft.com/mssql/server" image. Then I have a script to create a new database with some tables with seeded data within
Suppose I have column with strings with digits and non-digits. For example 1a2b~#3c. How can I find sum of the digits in these strings. I can't use CTE and my q
Preface: this isn't homework - I am learning SQL. I was given the problem to make a multiplication chart. Here's my solution: create table x (x int) create tabl
I am trying to connect to SQL Server in our domain network. I am able to connect using python but not able to connect in Node.js using Tedious. Node.js code sni
Recently, while working in SQL Server, I got an interesting thing that removing DISTINCT keyword actually decreased my query performance and increased my search
I have a column called “Month Year Raw” that has multiple nvarchar type data like this: 202201 and I want to convert that to a column called “
I am switching from MySQL to SQL Server for a new job and I have encountered something I don't quite understand as I haven't encountered something like this bef
var countryCode = new SqlParameter("@countryCode", SqlDbType.VarBinary); var byteArray = Encoding.UTF8.GetBytes(dto.Country); countryCode.Value = byteArray; var
I have a number of GCP Cloud Sql SQL EXPRESS 2017 instances that I'd like to upgrade to standard editions. Ive considered just spinning up a standard edition in
I have a table with a column holding the schema (key, type) of a JSON object, and another table with a column holding instances of objects described by that sch
I have this code public void insertAssignment(long mediaEvent_ID, long mediaBranch_ID, int? isPremiere, int? isNew, int? isLastChance, int? isPrevShown, int
I am trying to get a query that will allow me to increase the salary of people who earn less than 2000, but I don't want the salary increase for these people to
My project setup uses mssql, tomcat9.0.59,java 1.8_322 and MSSql driver is mssql-jdbc-10.2.0.jre8.jar. TLS 1.2 is enabled database server, after patching. Quest
My project setup uses mssql, tomcat9.0.59,java 1.8_322 and MSSql driver is mssql-jdbc-10.2.0.jre8.jar. TLS 1.2 is enabled database server, after patching. Quest
I've found lots of reported issues related closely to this, but nothing that's quite a match. I'm building a very simple C# class, with the intention of adding