I would like to be able to see the effects of running a Stored Procedure that someone else has written or other SQL code on a production datab
I am working on a C# project with a Microsoft SQL Server database. This is how I have connected the database: DataSet ds_display = new DataSet(); SqlDataAdapte
My goal is to continue in the procedure only with the database selected if it contains a specific table and a specific column. So that I don't get an error mess
I'm looking to update SQL Server in a single query based on a date, however the value updated depends on whether it is greater or lower than a provided value (i
Edit: SQL Server 2016. I'm running several xml.modify statements that all use pretty much the same path. I originally put an example that didn't match my err
I am using this table and data where all children of a parent node are uniquely named. CREATE TABLE [dbo].[Resources]( [Node] [hierarchyid] NOT NULL, [N
My team is trying to get Liquibase-formatted SQL to work with SQL Server Enterprise. We have no problem creating tables, but whenever we try to create a stored
I'm trying to make up a calculated column that evaluates an existing column with a CASE statement. The following code works fine: CASE WHEN Technician_Produc
Here is the question:count how many people who buy the same item at second time and how many people who did not buy the second item at second time (compare to b
I am facing a peculiar problem. I have a few tables in SQL Server where I have properly declared a few columns as decimal(18, 2). Unfortunately, whenever, I sav
I am writing a python script that should update a log table and notify me of it. Part of this script is to execute a SQL Server stored procedure. I get an email
Thanks everyone, and thank you @Aaron Bertrand, your answer solved my problem :) ! i am struggling to find a solution to my problem, here is my query in SQL Ser
I am using SQL Server Management Studio v18. I have an original transaction that might get adjusted either by amount or by commission%. I want a query to total
I have, for example, the following table: Client ID Function 1234 RE 1234 WE 1234 SP 1234 AG 6789 AG 6789 WE And I want to get only 1 client ID but that obeys
I need to proxy MSSQL connections over a TCP proxy using cached kerberos credentials. The idea is to authenticate against the database with kerberos, cache the
When I tried to convert the yyyymmdd (DT_Wtsr, string, len 8) to DATE datatype (yyyy-mm-hh) using the below expression: (DB_DATE)(SUBSTRING([Column],1,4) + "-"
I made a code allowing me to GET data from an API and insert it into a database. But I encounter a problem my api contains about 20 million data and to insert e
After adding SID to the TRANSACTIONS table, I need to update SID column in TRANSACTIONS based off STORE_NBR in the STORES table. Basically, I want to update the
Environment: Windows 2016 Server Standard PowerShell 5 Has Internet connection Running PowerShell as administrator JFrog is something new we're implementing but
A data file is imported to a SQL Server table. One of the columns in data file is of text data type with values in this column to be integers only. The correspo