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
I have this sample query: context.BarcodeTipiDoc.AsQueryable().Where(d => d.Barcode.CompareTo(minBarcode) > 0); That query runs very slow because Entit
I have two tables, Semester1 and Semester2. Semester1: StudentId SubjectId abc sub1 def sub1 ghi sub1 Semester2: StudentId SubjectId abc changedSub1 def sub1
I am trying to extract the data from an XML file that has many duplicates and if I change the name it is not showing anything in the result, I am not able to do
I want to remove the first word from a large string in SQL Server. Input string: 931078027 BP 16:20:0:13 25 BAG 'B' CLASS Desired output: BP 16:20:0:13 25 BAG
I'm trying to connect my ASP.NET Core MVC application to SQL Server. I'm using the Visual Studio for mac. I wrote the connection string like below : "Connect
I have a couple tables (see reproducible code at the bottom): tbl1_have id json_col 1 {"a_i":"a","a_j":1} 1 {"a_i":"b","a_j":2
I want to connect the Wordpress pluggin wpdatatables to my Ms sql database, but every time i try it appear the next message: "wpDataTables could not connect to
I have this stored procedure that selects the top 10 results from its inner join CREATE PROCEDURE SP_SELECT_DOCS_WHERE_JOBID_STATUS @JobID INT, @BatchID
I just created the project using the command dotnet new angular -o <output_directory_name> -au Individual and scaffold identity then I installed Microsoft
I have a staging table which contains all varchar columns. I want to validate a date stored in the data column. Since my staging table contains all varchar colu
Hi everyone I have a sql server table that contains fields that are of type varbinary. The table model sees the field as a string, when it tries to save it it g
When I am trying to execute a SSIS package from the SQL Server Agent Job, I get this error: Executed as user: WEATRUST\Prod_SSIS_Service. Microsoft (R) SQL Ser
I have a process using the following select statement in sql server SELECT HASHBYTES('SHA1', CAST('4100119300' AS NVARCHAR(100))) AS StringConverted This give
I have a very basic SSIS package with one SQL Task. It works fine in Visual Studio 2019 but doesn't run in SSMS or via DTEXEC on the server. I have my package