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
I have downloaded and installed Visual Studio 2022. Then after click on modify Now, I want to create SSIS package, for this I have started VS22 and in "manage
I'm trying to store DDLs of some views and stored procedures in a separate table in the Dump database. There are too many similar databases on the server. But s
I'm building a stored procedure to log table/procedure and need to be able to pull (not specific to current stored procedure) all parameter names and values. Th
I am trying to improve the performance of insert in SQL Server. INSERT INTO [dbo].[GroupCustomerAccountProductRebates]([GroupId],[GroupName],[ProductId],[Manufa
I have a script similar to below and get: Could not find server '@CURSERVER' in sys.servers. Verify that the correct server name was specified. If necessary, e
I'm using Pandas with latest sqlalchemy (1.4.36) to query a MS SQL DB, using the following Python 3.10.3 [Win] snippet: import pandas as pd
I'm trying to sum values inside a window function but I can't figure out have to prevent summing duplicates. Below is a snippet of the results I have right now.
I have an Excel document that is constantly updating it's values every couple of seconds through a link. Is there a way I can trigger some kind of stored proced
I'm using Django and mssql-django backend to connect to SQL Server. No problems to connect to SQL Server when using sql login. But, when I try to connect using
When I use following connection string I can connect Server=MYSERVER;Trusted_Connection=True; Following Fails Server=MYSERVER;Initial Catalog=MYDATABASE;Trusted
I have a simple sounding requirement that has had me stumped for a day or so now, so its time to seek help from the experts. My requirement is to simply roll-up
I had setup a WSL2 Ubuntu. Now I am running a local SQL Server instance on the 1401 port using Docker. Container port: 0.0.0.0:1401->1433/tcp I would like