Recent questions tagged SQL

0 votes

521 views

1 answer

sql - How to copy structure and contents of a table, but with separate sequence?

I'm trying to setup temporary tables for unit-testing purposes. So far I managed to create a temporary table which ... a new sequence by hand? See Question&Answers more detail:os...

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

0 votes

601 views

1 answer

sql server 2005 - Replace null character in a string in sql

I need to replace a null character in a sql string, i cant seem to find the right command to achieve this. I ... work, any help would be great See Question&Answers more detail:os...

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

0 votes

660 views

1 answer

sql - Oracle client and networking components were not found

I created SSIS will do task like get data from oracle to sql server.i run ssis package run in my local ... let know if any solution there? See Question&Answers more detail:os...

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

0 votes

565 views

1 answer

sql - How do I return a new IDENTITY column value from an SQLServer SELECT statement?

I'm inserting into an SQLServer table with an autoincrementing key field. (I believe this is called an IDENTITY ... statement, if possible? :) See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

sql - What is the affect of CONVERT() on INDEX while searching?

I am using SQL Server 2008. I have a Non-Unique Non-clustered index on a DateTime Column "DateFrom". I am ... this is not a proper question. See Question&Answers more detail:os...

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

0 votes

669 views

1 answer

sql server - Why does a Recursive CTE in Transact-SQL require a UNION ALL and not a UNION?

I get that an anchor is necessary, that makes sense. And I know that a UNION ALL is needed, if your ... the hood already, I would think. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

sql server - SQL won't insert null values with BULK INSERT

I have a CSV file and each line looks similar to this: EASTTEXAS,NULL,BELLVILLE AREA,NULL,BELLVILLE AREA,RGP,NULL, ... I'm doing wrong here? See Question&Answers more detail:os...

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

0 votes

629 views

1 answer

sql - MYSQL SUM GROUP BY

I'm working on a high school grading system. At my school, grades can be changed by reworking problems and I ... sub-select. Any other thoughts? See Question&Answers more detail:os...

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

0 votes

920 views

1 answer

sql - How do I list all the column names in Netezza?

Is there a query I can write to search all the column names for a particular database in Netezza? See Question&Answers more detail:os...

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

0 votes

489 views

1 answer

sql - MySQL: Limiting number of results received based on a column value | Combining queries

I've done research on this problem, but am having trouble finding a solution. I have the following query that ... less complex. Many thanks! See Question&Answers more detail:os...

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

0 votes

611 views

1 answer

sql server 2005 - Add a SQL XOR Constraint between two nullable FK's

I'd like to define a constraint between two nullable FK's in a table where if one is null the other needs a ... points, is this a bad idea? See Question&Answers more detail:os...

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

0 votes

582 views

1 answer

sql - column order in SELECT * statement - guaranteed?

I am using an ORM (sqlalchemy) to fetch data from a PG database. I want to avoid specifying all the table column ... an ORM, but needs must ... See Question&Answers more detail:os...

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

0 votes

668 views

1 answer

sql - openrowset for excel: can we skip several rows?

I will use the following sql to read data from excel, but sometimes I need to skip first several rows. e.g the ... 'SELECT * FROM [sheet1$]'); See Question&Answers more detail:os...

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

0 votes

637 views

1 answer

sql - oracle: can you assign an alias to the from clause?

can you assign an alias to the from clause? like: select a - b "Markup" from retail a, cost b; EDIT: sorry i ... 4 as b) but that isn't working See Question&Answers more detail:os...

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

0 votes

766 views

1 answer

sql server - What is TDS Protocol Version 8.0 and why should I use it?

I've been using FreeTDS with 8.0 protocol for some time to connect to a MSSQL Database, and things have worked ... and why should I use it? See Question&Answers more detail:os...

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

0 votes

545 views

1 answer

sql server - Read .NET configuration from database

The .NET 2.0 and up configuration system is quite powerful and extensible - as long as you don't want to change the fact ... ........ (YIKES!!!) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

sql - SSRS Grey out Parameter based on result from other Parameter

I wondered if it was possible to grey out a parameter based on the the result from another parameter? In ... thanks in advance for any replies See Question&Answers more detail:os...

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

0 votes

617 views

1 answer

sql server select column by number

Can I select specific columns by the number of the columns in SQL? Something like SELECT columns(0), columns(3 ... columns(8) FROM TABLE Thanks See Question&Answers more detail:os...

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

0 votes

760 views

1 answer

sql - TOP versus SET ROWCOUNT

Is there a difference in performance between TOP and SET ROWCOUNT or do they just get executed in the same manner? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

sql - Exporting a PostgreSQL query to a csv file using Python

I need to export some rows from a table in a PostgreSQL database to a .csv file using a Python script: #!/usr/ ... wrong or give me a tip about? See Question&Answers more detail:os...

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

0 votes

941 views

1 answer

sql - Entity Framework and CROSS/OUTER APPLY

I want to create some test cases for Entity Framework queries that surely generate SQL commands that contain CROSS ... of SQL queries appear? See Question&Answers more detail:os...

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

0 votes

652 views

1 answer

sql server - How SQL's convert function work when converting datetime to float?

why the out put of this query: declare @currentDate as datetime set @currentDate ='01/07/2010' select convert( ... query without executing it ? See Question&Answers more detail:os...

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

0 votes

723 views

1 answer

sql - Duplicate columns with inner Join

SELECT dealing_record.* ,shares.* ,transaction_type.* FROM shares INNER JOIN shares ON shares.share_ID = dealing_record. ... how to solve this. See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

sql - Get last deleted ID in MySQL

Similar to LAST_INSERT_ID(), is there a nice mechanism in MySQL to get the last deleted ID after a row has been deleted? See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

sql - MySQL's HEX() and UNHEX() equivalent in Postgres?

I'm in the process of converting some tools over that are using MySQL to PostgreSQL. With that, I've run into ... hash WHERE status = %s Thanks! See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

sql - How does order by clause works if two values are equal?

This is my NEWSPAPER table. National News A 1 Sports D 1 Editorials A 12 Business E 1 Weather C 2 ... me understand how is it happening? See Question&Answers more detail:os...

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

0 votes

578 views

1 answer

sql server 2008 - Is there a big technical difference between VARBINARY(MAX) and IMAGE data types?

I was reading on internet these statements about SQL Server data types: VARBINARY(MAX) - Binary strings with a ... data field in SQL Server? See Question&Answers more detail:os...

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

0 votes

677 views

1 answer

sql - Dropping unnamed constraints

I've created some foreign keys without an explicit name. Then I've found SQL generated crazy names like ... and the fields in question? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags