13 questions from the last 7 days
Advice
0
votes
3
replies
65
views
Procedure to show percentage of nulls in TERADATA SQL ASSISTANT
I'm working in Teradata SQL Assistant and I need to create a stored procedure that, given a table name, returns the percentage of NULL values for each column in that table.
Right now, I generate the ...
- 67
-3
votes
0
answers
91
views
Should I keep a table name as "platform" when PLATFORM() is apparently an undocumented function in SQL Server / T-Sql? [closed]
I created a table in SQL Server 2016. The table is named platform. When I typed
INSERT INTO platform (foo, bar) VALUES (1, 2)
the word platform was pink, as if it was a function. So I tried
SELECT ...
- 52
-3
votes
1
answer
52
views
Connecting SQL Server to Cypress
I am trying to connect the DB for testing web elements that have dependencies on data, and in general to add some reliable BE testing.
Currently I have cypress.config.js:
// cypress.config.js
const { ...
- 25
0
votes
0
answers
70
views
EF Core 9 migration fails on production database copy with "Cannot release the application lock" error
I'm using EF Core 9 and I'm trying to run a migration against a copy of our production database.
On our local development databases everything works, but on the production copy the migration fails ...
- 633
0
votes
0
answers
67
views
Long-running procedure being terminated before finishing
We have an End-to-End process which loads data into a Landing database. It used to run individual repopulate scripts for each data source in sequence, but that was taking more and more time to the ...
- 19
-5
votes
1
answer
129
views
Excluding NULL from a comparison [duplicate]
I've got a query which I will simplify it to be:
SELECT *
FROM BLAH
WHERE PPO_DISC_ID NOT IN ('009-003')
AND PPO_DISC_ID NOT LIKE '20%'
AND MyNum = '30788'
My problem arises when PPO_DISC_ID is ...
- 8,492
-1
votes
0
answers
22
views
SQL Server Express Master database corrupted tables [migrated]
I'm helping out someone where it looks like their previous developer stored some data tables in the Master database in SQL Server Express 2014. I don't know if it was to see if one could get around ...
- 75