Tag: sql

SQL Server : select first occurrence from two columns

(Edit: I am bound to use Visual Studio 19 and have no rights to install any other application) I have a small SQL table with about 150k rows and 20 columns which I need to modify. I need the table to be ordered by date. I need the first occurrence of a value from two columns. Depending on if the

Filter msdb.dbo.sysjobsteps.command into seperate columns

split sql sql-server tsql

I am trying to split the msdb.dbo.sysjobsteps.command column into separate columns to show the following information: folder project dtx package A small sample of my data is below: I have tried to use the substring method, however I cannot seem to get the starting and ending number of the substring. My aim is…

Way to alter one table if another was altered

ddl oracle oracle11g plsql sql

For example, I am having table T1 and archive table T1_A Create table T1(n number); Create table T1_A(archieve_dt date,n number); To make activation working correctly if I am adding a column to T1 …

getting error in Sql Query incorrect syntax near ‘)’ [closed]

error-handling mysql sql

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers. Closed las…

Tag: sql

SQL Server : select first occurrence from two columns

Filter msdb.dbo.sysjobsteps.command into seperate columns

Way to alter one table if another was altered

getting error in Sql Query incorrect syntax near ‘)’ [closed]

MySQL – ORDER BY multiple words, then alphabetically?

SQL `SELECT ‘some string value’ AS fieldname` equivalent in Powershell?

Using replace() inside a loop

Update column – remove first and last characters

T-SQL – Adding FK to table, make it do drop/null/efault automagically?

SQL perform AVG after MAX