So I am trying to run this SQL command Select Replace('[1,2,3,47]','%[0-9]\,|\[|\]%',''); this regex should give the following result 47 however, the original
I started to develop a .NET Core Web API application with SQL Server. I use the Windows Subsystem for Linux (I store the files in the Ubuntu s
I am working with Microsoft SQL Server and want to find E_ID and E_Name where T1+T2 has the MAX value. I have two steps to reach the necessary result: Find the
I have a CTE on which i am filling null values with the previous value before row 100 available by using the following script SELECT [YearMonth],grp, CASE WHEN
CREATE TABLE EventLog ( EventID INT , EventName VARCHAR(50) NOT NULL , EventStartDateTime DATETIME NOT NULL , EventEndDateTime DATETIME NULL ) INSERT IN
I have an IDbConnection to a SQL server and two stored procedures I would like to start from a console app using the Execute method on the open connection. When
We have a list with a sequence number. The sequence will break, then begin again. As you can see below, the SalesOrderLine is missing the number 4. SalesOrder
I would like to be able to recursively find all relationships in a table. I have a relational table, and essentially I would like to apply the transitive proper
I am struggling to get the nearest 'Math Test' or 'Biology Test' in (+/- 3 hours) from Test= 'Marked A+' including TestOrder ordering. If 'Math Test' or 'Biolog
I'm a beginner in SQL and I need your help please! I have a project which is convert Social Security Numbers into birth date. In the database, I have a column M
I'm testing jQuery AJAX to return data from a SQL Server table. In the AJAX call I have a failure function to show any potential errors in an alert box. However
Please can someone give me guidance on how to set up anonymous read-only access to one specific table in Azure. I have a table that I want Power BI students to
We are soon to migrate our back-end from an Amazon SQL Server RDS to another identically set up RDS server. We intend that our systems will not be interrupted b
This SQL gives me the blog comments that contain just the banned words defined in my table. I only get the EXACT matches and it removes duplicate rows. It also
I'm trying to understand annotations better with JPA / Hibernate and SQL Server. I created a simple project: an abstract class named "Articles". Two classes inh
I have a script that I want to be able to schedule to run periodically, and query a DB, open a connection, execute a query, then close the connection. Trying to
I have the following three tables. See full db<>fiddle here members member_id first_name last_name 1 Roby Dauncey 2 Isa Garfoot 3 Sullivan Carletto 4 Jac
I am having trouble getting Visual Studio 2022 (and 2017) to work with a simple Database Project. I have extracted a data tier application and stored it as a .
I have a docker compose file which creates a starts SQL Server. This is working fine. I can connect to the database and see the master database. What I am tryin
[Enter image description here] 1 I got this error when I tried to run the system. I am not sure why. it used to display the information from a database. Please