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
I ran an insert query on a table in SQL Server by mistake and 100 rows got inserted. I want to undo it but I do not have rollback.
I have data that looks likes: stu_id course_name staff_name 1 Economics - 3 Kuzma, Brian 1 History Hulings, Kreg 1 IHS IB Lit of Americ Duncan, Amy 2 Marine Bi
I've been trying to deploy a database via a pipeline from Azure DevOps to an Azure resource group. I have an ARM template for my database server in my Repo alon
i have this query i want the user to search with the name without uppercase or lowercase , how can i do this ? join Materiel in ds.
The column does exist in the table, however when I run this query, I get an error of "unknown column". I ran explain & describe to double-check my table Er
I have created two SSRS reports within a Report Project using VS 2019 and they work fine. When I create a third report using the same procedure and attempt run
My database is SQL Server. I have the following sql querySELECT RQI,RQIOver,PCI,PCIOver,PQI,PQIOver,SR,SROver,IRI,IRIOver,RUT,RUTOver,cast(DateCollected as date
UPDATE: It appears that when setting filters or loading the datasheet, access is taking a strange and inconsistent amount of time to load the records. I set a f