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
I have a table with a column of datatype XML. I want to get data by reading that XML column. Here is the XML which is stored in that column: <BizMsg xmlns:xs
probably someone has encounterd the same problem and have a solution. I have a SQL Database in my Azure Portal account. I have created a NodeJS application in a
I have a table where as codes are present in the form of 78,7244,d345 by default few records are found where the codes are start with 0072 . I have to delete st
I have this piece of code which acquires connection from EF Core DB context and executes select on the received data. var conn = _dbContext.Database.GetDbConnec
When running the below in /superset/sqllab/ ";WITH cteData AS ( SELECT TOP (100) * FROM [dbo].[Response] ) x SELECT * FROM cteData" I get the following error:
I'm attempting to connect into a SQL Server DB I have hosted on my Linux VM. I'm running xampp on my development windows machine and the connection is coming fr
I'm trying to create a stored procedure that backs up a database, however whenever I execute it, the folder I'm trying to backup to remains empty. Here is my st
I have two tables match_score and match_condition I want to update table match_condition and set values of innings, first_4, etc. Here's the example in which I
I would like to get first day of continuous date sequence. Query is valid for one month. I am using SQL Server 2014. Table example: Id | VechicleISO | RideISO |
I'm writing different queries in SQL Server. I have 2 tables, Employees and Departments. Table Employees consists of EMPLOYEE_ID, ENAME, ID_DEP - department id.
I am trying to query data from linked server. It is giving me the following error: TNS:listener does not currently know of service requested in connect descrip
I have a c++ application and run it on SQL Server 2019 server1\db1 - it works fine server1\db2 - it works strange The app works different. I have detected in Pr