13 questions
If there are 10 pieces of data, we will take out data from 1st to 10th, compare it with data from other tables, and then process INSERT or UPDATE. I wonder if there is a grammar that can be compared b...
There is a dedicated factory control program that is in use with MSSQL Server 2012?, and is developed for it - and there is no room for further development.Now, this factory control program is sending...
The following are the actions I want to do. SQL statement that returns a complete list of tables with a specific column nameSELECT TABLE_NAME FROM information_schema.COLUMNS where COLUMN_NAME = 'The n...
Hello seniorsThe query I'm looking for now is Hello World, This is sample codein the string When you look for the word sample,I'm trying to pull out an index that corresponds to 'e' (last index of the...
To be exact, when you insert the LEVL1 and LEVL2 columns, you add +1 to the record value of LEVL1I want to reflect it in LEVL2 When I saved it as Merge into, I created a query... How can LEVL2 reflect...
SELECT D.dev_serial ,D.dev_name /* /* location */ ,case when charIndex(']', dbo.funcSplit(dbo.funcSplit(D.dev_name, '(', 1) , '_', 3)) > 0 then dbo.funcSplit(dbo.funcSplit(dbo.funcSplit(D.dev_name,...
I want to create a data frame with Python's Pandas and insert it into mssqlData frames are formed in 14 columns at an average of 250,000 rows.sqlalchemy.create_engine to insert the whole in sql form, ...
select T.test_col ,MAX(T.test_co) as max_test ,max_test as max2 -- I want to use the column information that I calculated earlier like this right away.from test_table TIs it completely impossible? O...
Ubuntu server is using spark. I installed hue, for scheduling and monitoringhue seems to support mysql, postgresql, and sqlite by default.How can I use it in conjunction with mssql of azure in hue?
DBeaver is using this and that database.By the way, I want to copy the database that I use by accessing DBeaver from another remote computer.How should I do it?
| - 1 - | » |
© 2024 OneMinuteCode. All rights reserved.