mssql tag

13 questions

2 answers
94 views
0

Is there a grammar like FOR sentence in MSSQL?

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...

mssql sql database

1 years ago

1 answers
119 views
0

Can I have an external program run when I trigger Insert?

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...

mssql trigger

1 years ago

1 answers
114 views
0

Query statements that have specific columns in multiple tables and find and delete conditions for their values

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...

mssql sql

1 years ago

1 answers
72 views
0

MSSQL Query - How do I get the last index of the string I'm looking for?

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...

mssql database

1 years ago

1 answers
104 views
0

How can I add 1 to the ms sql/column?;;

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...

mssql

1 years ago

1 answers
63 views
0

Is there a way to use the column bar that I made in mssql select?

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,...

mssql sql mysql

1 years ago

2 answers
98 views
0

How can I quickly insert a data frame with a large python capacity into msql?

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, ...

python mssql sql-server

1 years ago

1 answers
82 views
0

Is there a way to call and use the newly created column right away when selecting in mssql?

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...

sql mssql database

1 years ago

1 answers
112 views
0

Can I link the mssql of azure in Hue?

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?

mssql sql-server hadoop

1 years ago

1 answers
71 views
0

I'm using DBeaver, how can I copy the database?

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?

database postgresql hadoop mysql mssql

1 years ago

- 1 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656