Recent questions tagged SQL

0 votes

370 views

1 answer

sql - Is id column position in Postgresql important?

I was testing a migration that deletes a primary key column id (I wanted to use a foreign key as primary ... in the migration revert code? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

685 views

1 answer

sql - PostgreSQL 9.3: Dynamic pivot table

I have a table called as matrix which contains two columns namely cola and colb as shown below: Table: matrix create table ... 0 0 0 0 0 0 1 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

606 views

1 answer

sql - Convert from date to epoch-Oracle

I need to convert a date from a TextBox from date to epoch time so that I can insert it into Oracle ... FROM CONTRACTORS ORDER BY COMPANY" See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

526 views

1 answer

sql - Error trying to call stored procedure with prepared statement

I'm trying to use a prepared statement to call a stored procedure (using ADODB with classic ASP), but ... help would be greatly appreciated. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

453 views

1 answer

sql - Selecting column names that have specified value

We are receiving rather large files, of which we have no control over the format of, that are being bulk-loaded ... like this possible to do? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

483 views

1 answer

sql server - How do you get to limits of 8060 bytes per row and 8000 per (varchar, nvarchar) value?

Comining from my question "8078 bytes in 8060 B datapage (SQL Server)?" where it was explained to me how to ... to manage, the more overhead... See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

650 views

1 answer

sql server - Merge multiple rows into a single row

I would like to know the best approach to merge data from the following rows into a single row in another ... with be very much appreciated! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

557 views

1 answer

sql - unable to cast value as float

We have a SQL that performs a CAST function (to FLOAT) on ColumnA. The SQL has a filter which in the end will ... solution is "not to do that!" See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

591 views

1 answer

sql - Why does the wm_concat not work here?

I have this query : (SELECT OBJECT_ID from cr_object_group_entries_vw where object_group_id IN (SELECT ITEM FROM TABLE( ... I doing wrong? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

829 views

1 answer

sql - H2 database column name "GROUP" is a reserved word

How do I create a table in H2 with a column named GROUP? I saw an example that used something like [*] a while ago, but I can't seem to find it. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

469 views

1 answer

sql - Difference Between Timestamps in Milliseconds in Oracle

I have table test1 and have one column DOJ with timestamp datatype having few records as shown below. Here i need ... please help me with this. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

777 views

1 answer

sql - C# SqlCommand - cannot use parameters for column names, how to resolve?

Is there any way how to do that? This does not work: SqlCommand command = new SqlCommand("SELECT @slot FROM Users ... Seems to me a bit ackward. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

637 views

1 answer

sql - Return rows in the exact order they were inserted

I have a simple join table with two id columns in SQL Server. Is there any way to select all rows in the exact ... an ORDER BY, isn't it? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

481 views

1 answer

sql server - T-SQL: checking for email format

I have this scenario where I need data integrity in the physical database. For example, I have a variable of ... in T-SQL? Many thanks! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

567 views

1 answer

sql server 2005 - SQL . The SP or function should calculate the next date for friday

I need to write a store procedure that will return a next friday date on a given date? for example - if the ... it should return the same date. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

770 views

1 answer

sql server - SQL Query Where Column = '' returning Emoji characters 🎃 and 🍰

Ok so I have a table with three columns: Id, Key, Value I would like to delete all rows where Value ... table name really is [Imaging.ImageTag] See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

677 views

1 answer

sql - Cannot bulk load. The file "c:data.txt" does not exist

I'm having a problem reading data from a text file into ms sql. I created a text file in my c: called ... select * from #temp drop table #temp See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

646 views

1 answer

sql - check bound datatable for null value vb.net

I am currently working in vb.net windows form applications with an sql back end. I have two datatables that are ... just going to crash on me. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

738 views

1 answer

sql - LEFT JOIN query not returning all rows in first table

Using management studio for SQL Server 2008 R2. Trying to do a LEFT JOIN and I need to return all rows from the ... with a 0 as it's stock. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

583 views

1 answer

sql server 2008 r2 - move cells left in sql if left contains null and right contains value

In Sql I am getting the result like below format. Totally i have 6 columns. in 1st row 6th column contains the ... am using SQL server 2008-R2) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

504 views

1 answer

sql - MS Access Limit

What's the equivalent of mysql Limit in ms access. TOP is not sufficient since I'm going to use it for pagination. Thanks See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

522 views

1 answer

sql - Oracle string aggregation

My table structure look like this, I am new for the this field. I know the basic queries ... 10002 Main_product Sub_product1,Sub_product2 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

536 views

1 answer

sql - The new PIVOT function in BigQuery

Today BigQuery released a new cool function called PIVOT. Se below how it works: with Produce AS ( SELECT 'Kale' ... a link to reddit cross-post See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

521 views

1 answer

sql server - Does query plan optimizer works well with joined/filtered table-valued functions?

In SQLSERVER 2005, I'm using table-valued function as a convenient way to perform arbitrary aggregation on subset ... thanks for your help! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

528 views

1 answer

sql server - How to use IF/ELSE statement to update or create new xml node entry in Sql

Example: <root> <StartOne> <Value1>Lopez, Michelle MD</Value1> <Value2>Spanish</Value2> <Value3> <a title="49 ... /StartOne/Value6)[1]'); END See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

572 views

1 answer

sql - MySQL groupwise MAX() returns unexpected results

TABLE: LOAN Loan_no Amount SSS_no Loan_date 7 700.00 0104849222 2010-01-03 8 200.00 0104849222 2010-02-28 9 300 ... me with my problem? Thanks. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

503 views

1 answer

sql server - What is the best practice for inserting a record if it doesn't already exist?

I know at least three ways to insert a record if it doesn't already exist in a table: The first one is ... the rest of the stored procedure. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

607 views

1 answer

sql - Using SSIS to extract a XML representation of table data to a file

I'm trying to use SSIS to extract XML representation of a query result set to a text file. My query is ... the console app and a scheduler. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags